Please tell me there's a honeysql-like library for python ๐ I've used pugsql in the past, which is inspired by hugsql, but now I need to work with a more dynamic schema so it's not a very good fit unfortunately
I think that the closest you can get in python is SqlAlchemy
Hey, thanks for the response. I actually asked at the python developers slack. Someone did recommend sqlalchemy core, which includes a query builder. Apparently it can be used separately from the ORM parts (yay!), which I didn't know. Another person recommended pypika, which is more lightweight. Unfortunately its api is not exactly functional but the library is definitely on my radar now.
Nice, eventually we need to work in other stacks, so itโs good to know what to use when it happens.