skip tests specific to PostgreSQL
strengthen the tests a bit
make the generated SQL a bit more portable (currently sufficient for SQLite)