prql-query
FunSQL.jl
Our great sponsors
prql-query | FunSQL.jl | |
---|---|---|
3 | 4 | |
115 | 138 | |
- | 1.4% | |
10.0 | 8.1 | |
7 months ago | 9 days ago | |
Rust | Julia | |
Apache License 2.0 | GNU General Public License v3.0 or later |
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.
prql-query
-
Relational is more than SQL
Thank you.
The CLI usability was one of the aims behind [prql-query (pq)](https://github.com/prql/prql-query/). sqlite integration was on the roadmap but unfortunately that project has been largely unmaintained by me for the past 6 months. (This is just referring to prql-query and not PRQL which is under very active development.)
I'm working on a new project which will do exactly this (and a lot more!) which I hope to release next week. I'll drop the link here when that's ready.
-
GQL: A SQL like query language for .git files
As an aside, I could also look at including GQL as a backend in pq (https://github.com/prql/prql-query/) which is my project. It's a bit badly maintained the last few months due to my time constraints but I want to do a big upgrade with the imminent PRQL 0.9 release.
-
PRQL a simple, powerful, pipelined SQL replacement
Thanks for the suggestion. I don't think I knew about usql. I completely agree with you and have been working on a cli tool called `prql-query` or `pq` at the command line:
https://github.com/prql/prql-query/
Unfortunately I haven't had much time to spend on it of late but hope to push some updates soon.
FunSQL.jl
-
PRQL a simple, powerful, pipelined SQL replacement
You might enjoy the FunSQL library; SQL verbs are represented using regular Julia objects and you pipeline them together to build bigger queries. A key difference to other SQL builders is that you assemble a tree of "tabular operations" instead of a SQL syntax tree.
https://github.com/MechanicalRabbit/FunSQL.jl
- FunSQL.jl – Julia library for compositional construction of SQL queries
-
PRQL is a modern language for transforming data — a simpler and more powerful SQL
The developers of HTSQL are working now on FunSQL – https://github.com/MechanicalRabbit/FunSQL.jl
-
SQL: The difference between WHERE and HAVING
There is no HAVING and the you can use any tabular operators in any order. Aggregates are also separated from grouping and can be used in any context after Group is applied.
[0] https://github.com/MechanicalRabbit/FunSQL.jl
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
TablaM - The practical relational programing language for data-oriented applications
cargo-semver-checks - Scan your Rust crate for semver violations.
DifferentialEquations.jl - Multi-language suite for high-performance solvers of differential equations and scientific machine learning (SciML) components. Ordinary differential equations (ODEs), stochastic differential equations (SDEs), delay differential equations (DDEs), differential-algebraic equations (DAEs), and more in Julia.
data-toolset - Upgrade from avro-tools and parquet-tools jars to a more user-friendly Python package.
tresql - Shorthand SQL/JDBC wrapper language, providing nested results as JSON and more
Linq2Couchbase - A Language Integrated Query (LINQ) provider for the Couchbase .NET SDK
ddl-diff - Generates SQL migrations by parsing and diffing DDL
Pluto.jl - 🎈 Simple reactive notebooks for Julia
TableIO.jl - A glue package for reading and writing tabular data. It aims to provide a uniform api for reading and writing tabular data from and to multiple sources.
SQLToy - Learn SQL by creating a SQL database in JavaScript