Alternatives
Products that do what It's been nearly 50 years. Is SQL outdated? does
Actually, the Q in SQL represents query. The original purpose of inventing SQL is to query (i.e., calculation), which is the main goal of SQL. However, it is hard to say that SQL is very competent when describing computing tasks. Here is an example that is actually not very complicated: calculate the maximum consecutive days that a stock keeps rising. Write it in SQL is like this: select max (consecutive_day) from (select count(*) (consecutive_day from (select sum(rise_mark) over(order by trade_date) days_no_gain from (select trade_date, case when closing_price>lag(closing_price) over(order…
- 1
- 2SH
2019 · sqlhabit.com
- 3
- 4
- 5ST
2018 · app.bytescout.com
- 6
- 7
- 8DS
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
- 9TE
2019 · github.com
- 10SS
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…
2022 · github.com
- 11PA
2021 · github.com
- 12
- 13SBSQL Basics▲26
2021 · garden.bradwoods.io
- 14
- 15
- 16
- 17QC
2021 · querycal.com
- 18
- 19
- 20
- 21
- 22
- 23ST
2015 · sqlteaching.com
- 24
Ranked by how close each launch is in meaning, then by votes. Refine with a description →