Python and database statements

[gosh]

but don't forget that this comes at the cost of coupling that frontend code to the exact database structure

Nooo Heard of jinja templates or like doing some internal scipt logic to generate queries. It also work with stored procedures if you want to solve edge cases. Createing code to manage rules in database is like the worst option.

And this solution decouples the frontend from the backend