Alternatives
Products that do what SPyQL – SQL with Python in the middle does
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
- 1CP
2020 · github.com
- 2
- 3
- 4
- 5SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021
- 6
- 7
- 8
- 9
- 10PA
2019 · pugsql.org
- 11
- 12
- 13
- 14
- 15
- 16SG
2019 · github.com
- 17
- 18DS
I played around with GPT-3 to build this demo. Select a public BigQuery dataset and describe your query in natural English, then edit the generated SQL as needed and execute it. https://app.tabbydata.com/sql-assistant-demo
2021
- 19MA
This app works with any GraphQL endpoint, it makes an introspection query on initialization and save the schema to prefix gpt requests and create/run queries. Mostly useful for people that want to access data from a database and don't know how to code in graphql.
2023 · github.com
- 20SI
2014 · github.com
- 21PA
2021 · github.com
- 22
- 23
- 24PS
Hi HN, I built py-sql-cleaner, a CLI for formatting SQL embedded in Python files. Python formatters handle Python syntax. They do not format SQL written inside Python code. On the other hand, SQL formatters usually target SQL files or raw SQL text, not SQL embedded inside a Python file. Still, I think it is not uncommon to find long SQL queries inside Python codebases. py-sql-cleaner detects embedded SQL inside Python files and works only on that SQL. The main things it can do are: find the SQL, format it in place, or extract it into a .sql file. It avoids rewriting SQL that depends on…
May 2026 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →