Add full support for alternate schemas

Currently there seem to be quite a few operations where the schema is not specified, and thus the default schema will be used. So if you specify anything other than the default schema in the database config, errors abound.

Would be good to add full support for this.