Hacker News new | ask | show | jobs
by wredcoll 303 days ago
I think what I just really want is a language that treats sql as a "first class" component in the same way perl treats regexes.

The devil is of course in the details, but it's a nice dream.
3 comments
weinzierl 303 days ago
Not quite first class citizen, but you might like sqlx. At least it embraces the idea that writing SQL directly is in fact a good idea and helps you to do so safely.

https://docs.rs/sqlx/latest/sqlx/

link
caspper69 303 days ago
LINQ? Just throwing it out there; obviously not everybody can or wants to run a C#/.NET stack, but entity framework (core) is about as close as you can get to the perl and regex integration. I think Ruby on Rails gets there too, but I'm not a RoR guy, so I can't comment.
link
wredcoll 302 days ago
I think linq is the closest anyone has come so far, although it is a dsl with slightly different semantics as I understand.

ActiveRecord, RoR's ORM is the complete opposite.

link
SoftTalker 303 days ago
> a language that treats sql as a "first class" component

pl/pgSQL (or pl/sql in oracle) and variants.

link