Here are some test cases for database abstraction as described in Database abstraction with google apps script
The library reference is
Once you have set up your environment you can use these test cases to try it out. Tests here are for a few different back-ends. Just modify to try out the one you are planning to use.
The code I used at the time of writing this is now deprecated. Please refer to here for GoA