Adding that on top of Mike's approach, you may also want to create some
custom functions via the @compiles decorator:
https://docs.sqlalchemy.org/en/14/core/compiler.html
This would allow you to further customize the SQL emitted against Postgres
vs SQLite as needed.For example, I have some
On Tue, Oct 19, 2021, at 1:41 PM, Jonathan Brandmeyer wrote:
> We're supporting both Postgres and SQLite in our application. For the most
> part, sticking close to ANSI has made this pretty seamless. However, there
> have been occasions where we want to write either DDL or DML in a
>
We're supporting both Postgres and SQLite in our application. For the most
part, sticking close to ANSI has made this pretty seamless. However, there
have been occasions where we want to write either DDL or DML in a
dialect-specific way.
For column data, we want to enable the use of JSON.