Re:For Want of a JOIN
by int_19h on Thursday December 22, 2022 @06:07PM
(#34100155)
A separate high-level language just for queries doesn't make much practical sense, since queries are normally surrounded by plenty of other code.
OTOH something like C# LINQ, which, on one hand, plays nicely with the rest of the language, and on the other, can be directly mapped to SQL (without ORM and other impedance-mismatch-inducing layering) is great. But, necessarily, language-specific to ensure tight integration.
OTOH something like C# LINQ, which, on one hand, plays nicely with the rest of the language, and on the other, can be directly mapped to SQL (without ORM and other impedance-mismatch-inducing layering) is great. But, necessarily, language-specific to ensure tight integration.