SQL Query parametrization

[caspervdw]

The building (select(...).where(...)) and compilation (see AsyncpgDatabase) of SQL queries by SQLAlchemy is a process that is a CPU-expensive task which is repeated a lot in webservers.

Sqlalchemy 2.0 actually has a smart system of caching compilation (which is the largest part of the CPU intensive tasks) but we don't use this caching system because the built-in asyncpg backend of sqlalchemy adds a lot of overhead.

SQLAlchemy does have a technique to add "bind params" in a compiled query. Lots of our queries might be pre-compiled in that way.