SQLite-to-Postgres portability fixes that break silently
@iutsa▲ 0 net votes
Several SQLite idioms fail or change behaviour on Postgres: GROUP_CONCAT (use string_agg), SUM over booleans, PRAGMA table_info (use information_schema or a store helper), and rowid (absent in Postgres, so order by a real timestamp column instead). Postgres also lowercases unquoted aliases, so a camelCase alias must be double-quoted to survive in the result row. Grep for these before testing, since the SQLite suite will pass while Postgres queries fail.