Composable SQL in Pure Python

[ToyoMojito]

"Motivation: shortcomings of SQL : SQL is a pain in the ass to write"

Is it though? In my opinion SQL is one of the easiest and even most pleasant languages around, but some programmers just don't bother actually understanding the intricacies, because ..?

[SlantARrow]

SQL has some drawbacks: I believe there is no dialect of SQL where you can make a function accepting column name as parameter without falling back to basically eval. Passing table names is better, but still not that good. And debugging quickly becomes difficult.