In the case of SQLite the simple queries are mostly compatible. When a boolean column is selected it is not considered a simple query as the result would be "true" | "false" which are both truthy.
In the case of Postgres a lot of number results are numbers where strings are expected and strings where numbers are expected.
In the case of SQLite the simple queries are mostly compatible. When a
boolean
column is selected it is not considered a simple query as the result would be"true" | "false"
which are both truthy.In the case of Postgres a lot of number results are numbers where strings are expected and strings where numbers are expected.