SQL Query Alternatives

Have you seen squeryl? Its not quite as nice as LINQ, but its definitely a useful DSL

As far as query languages go, you may want to look into prql, kusto or google's alternative (i forgot its name). They are composable, and more natural.

That looks like going back to imperative/functional instead of the declarative syntax of SQL...Have you used C# before? I think the LINQ query syntax could be a good evolution for some uses cases, but it again goes back to decades of dialects already being defined. Seems anything new would have to be implemented as some kind of proxy that then maps back to SQL or uses low level db access, but then why not just use an ORM or query builder in the first place and query from inside a languag

PRQL: a simple, powerful, pipelined SQL replacementhttps://news.ycombinator.com/item?id=34181319Also: https://github.com/ajnsit/languages-that-compile-to-sql

You may like PRQL, which gives a more composable-atoms based approach. I find it far easier than SQL.

This is like the lambda / Linq on .NET. Well done. Take a look at PRQL too. You may enjoy it, it may even help you simplify query transformations to sql.

For the last year, I've been working on a query language that aims to replace SQL and data frame libraries. It's continuation of my work on PRQL and EdgeQL.Now I need feedback on usability, ergonomics and overall design. Read trough the examples, check out the CLI & tell me what could be better.

Do we need another language for querying relqtional data? Why not just use SQL?

Related:PRQL: Pipelined Relational Query Language - https://news.ycombinator.com/item?id=36866861 - July 2023 (209 comments)PRQL: a simple, powerful, pipelined SQL replacement - https://news.ycombinator.com/item?id=34181319 - Dec 2022 (215 comments)Show HN: PRQL 0.2 – a better SQL - <a hre

Something like this:https://en.wikipedia.org/wiki/Language_Integrated_Query