pyprql
Kusto-Query-Language
pyprql | Kusto-Query-Language | |
---|---|---|
1 | 1 | |
89 | 496 | |
- | 2.2% | |
9.1 | 8.9 | |
7 days ago | 11 days ago | |
Python | C# | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pyprql
-
PRQL, Pipelined Relational Query Language
Not quite what you're asking for but DuckDB has both PRQL [1] and Postgres [2] extensions, so you could probably query your Postgres database with PRQL from there.
There's also a DBeaver plugin [3] which we still need to document better and simplify the usage of but you could potentially also use that to query Postgres with PRQL.
Finally there is pyprql [4] with which you could query Postgres from a Jupyter notebook.
[1]: https://github.com/ywelsch/duckdb-prql
[2]: https://duckdb.org/docs/extensions/postgres_scanner.html
[3]: https://github.com/PRQL/prql/issues/1643
[4]: https://github.com/PRQL/pyprql
(Disclaimer: I'm a PRQL contributor.)
Kusto-Query-Language
-
PRQL, Pipelined Relational Query Language
Note that Kusto Query language is open source see https://github.com/microsoft/Kusto-Query-Language
What are some alternatives?
chdb - chDB is an embedded OLAP SQL Engine 🚀 powered by ClickHouse
dbt-prql - dbt-prql allows writing PRQL in dbt models
duckdb-prql - PRQL as a DuckDB extension
ClickBench - ClickBench: a Benchmark For Analytical Databases
SQLpage - SQL-only webapp builder, empowering data analysts to build websites and applications quickly
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
Preql - An interpreted relational query language that compiles to SQL.
ClickHouse - ClickHouse® is a free analytics DBMS for big data