Re:Modern SQL in PostgreSQL
by juliangregorian on Monday February 09, 2015 @04:00AM
(#9020264)
I often find myself wishing that SQL had a more uniform syntax. So much of it resembles COBOL to me, with all the capital letters and "english-like" arbitrary word order. At the same time, relational algebra exists and is very elegant, in an APL-like way. Would be very interested if there was a project to expose such an api to SQL databases.
[ Parent
| on HN ]
SQLAlchemy (for python) tries to sanitize the syntax away from SQL with some level of success.
SQL is case insensitive. It is a bit quirky though.
Re:Modern SQL in PostgreSQL
by domoarevil on Monday February 09, 2015 @08:28AM
(#9021013)
Indeed, something people forget sometimes leading to collation problems in the (odd) instance when CS is set.
Re:Modern SQL in PostgreSQL
by juliangregorian on Monday February 09, 2015 @04:45AM
(#9020376)
True, but very few people write it as anything but.