Agreed, writing db queries in Python is just plain pain compared to C# + EF. Loved how I have to handle runtime type errors for SQLAlchemy queries in a dynamically typed language.

Other aspects of it are fine, but this exact part strongly feels doing something un-python in python for me.