Show HN: ScopeQL, a new query language based on relational algebra

https://www.scopedb.io/blog/scopeql-origins

by tison • 1 year ago

1 2 1 year ago

scopedb.io

xq3000• 1 year ago

Could this also be implemented as an ORM DSL to interface traditional SQL databases?

tison• 1 year ago

Not quite. As described in the FAQ:

What about the interoperability with SQL?

Some libraries and tools enable developers to write queries in a new syntax and translate them to SQL (e.g., PRQL, SaneQL, etc.). The existing SQL ecosystem provides solid database implementations and a rich set of data tools. People always tend to think you must speak SQL; otherwise, you lose the whole ecosystem.

But wait a minute, those libraries translate their new language to SQL because they don't implement the query engine (i.e., the database) themselves, so they have to talk to SQL databases in SQL. However, ScopeQL is the query language of ScopeDB, and ScopeDB is already a database built directly on top of S3.

Thus, what we can leverage from the SQL ecosystem are data tools, such as BI tools, that generate SQL queries to implement business logic. For this purpose, one should write a translator that converts SQL queries to ScopeQL queries. Since both ScopeQL and SQL are based on relational algebra, the translation must be doable.

Show HN: ScopeQL, a new query language based on relational algebra

Related Stories