Add `compile_query` function to compile `sqlalchemy` queries

[dhirschfeld]

• https://docs.sqlalchemy.org/en/20/faq/sqlexpressions.html#rendering-bound-parameters-inline
• https://copdips.com/2020/06/compiling-sqlalchemy-query-to-nearly-real-raw-sql-query.html

[dhirschfeld]

Something like the below should work:

import sqlalchemy as sa
from sqlalchemy.engine import Dialect, URL
from sqlalchemy.sql.compiler import SQLCompiler
from sqlalchemy.sql.selectable import Select


def get_dialect(name: str) -> Dialect:
    from importlib import import_module
    mod = import_module(f"sqlalchemy.dialects.{name}")
    dialect = mod.dialect()
    dialect.default_paramstyle = 'qmark'
    dialect.paramstyle = 'qmark'
    dialect.positional = True
    return dialect


def compile_query(query: Select, *, dialect: str) -> tuple[str, tuple]:
    dialect: Dialect = get_dialect(dialect)
    compiled = SQLCompiler(dialect, query)
    SQL = str(compiled)
    params = compiled.params
    if dialect.positional:  # type: ignore
        params = tuple(params[key] for key in compiled.positiontup)
    return SQL, params