2 ms·
> Learning straight SQL is far more transferable across databases than learning an ORM. Not my experience. For example a recursive/tree query usually has one w
by lmm 4y ago
> Learning straight SQL is far more transferable across databases than learning an ORM.
Not my experience. For example a recursive/tree query usually has one way to do it in an ORM, but three or four different ways to express it in SQL depending on the database, some of which seem like they're wilfully screwing you over (one popular database requires you to only write "WITH" and won't recognise "WITH RECURSIVE"; another requires you to write "WITH RECURSIVE", even though the error message it gives you when you only write "WITH" tells you that it knew exactly what you meant).