BI and analytics tools often require writing SQL (so 90's) ...
Is there a way to write EdgeQL and generate the corresponding SQL? That would be so much better!
Is there a way to write EdgeQL and generate the corresponding SQL? That would be so much better!
It would be possible however, to take an empty postgres instance, hook edgedb server to it, apply your schema and insert all the data.
You can write analytic queries with EdgeQL now, albeit we do need to add support of windowing. While we certainly prioritize usefulness of EdgeQL for the kind of efficient data fetch operations you need when you build apps and services, the language itself was designed with a goal of becoming equally good for analytics too. We'll get there.