Re:What ORMs have taught me: just learn SQL
by jl6 on Tuesday August 05, 2014 @02:50AM
(#8135841)
>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.
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.