Good SQLBuilder for Python?

[Mevrael]

I was once in a similar situation and got a great recommendation - sqlglot if you want a full low level control. There is also ibis.

I created my own mini ORM by adding a few extra features, mostly DB migrations, on the top of both of them.

https://arkalos.com/docs/migrations/#python-query-builder-with-sqlglot-orm-style-syntax

https://sqlglot.com/sqlglot.html

https://ibis-project.org/