>The main problem with raw SQL is that what you really want is a genuine programming language. In my experience, if you take a data-oriented approach (where yo

>The main problem with raw SQL is that what you really want is a genuine programming language. In my experience, if you take a data-oriented approach (where you add value through structuring/modelling data), SQL is just fine. If you take only an application-oriented approach (where you add value by making use of data), you may be tempted into viewing the database as a dumb object store, and SQL starts to creak. Having said that, in the cases where I have wanted composable SQL, SQLAlchemy has done a fine job.