Dev tools · alternatives · 2026

24 alternatives to ClickHouse User Defined Table Function in Python

Query on Everything with SQL. Contribute to auxten/SQL-On-Everything development by creating an account on GitHub.

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. ClickHouse User Defined Table Function in Python launched in 2024; newer entries below may have overtaken it.

1. 1
   FSQL – Search through your file system with SQL-esque queries▲341

   Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

   2017 · github.com · its alternatives →

2. 2
   chdb▲88

   Embedded SQL OLAP engine powered by ClickHouse

   2023 · clickhouse.com · its alternatives →

3. 3
   Csql – Python lib for composeable SQL queries▲89

   Contribute to akdor1154/python-csql development by creating an account on GitHub.

   2020 · github.com · its alternatives →

4. 4
   Simple interactive SQL exploration with IPython/Pandas▲22

   Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.

   2014 · github.com · its alternatives →

5. 5
   I wrote a RDBMS (SQLite clone) from scratch in pure Python▲371

   I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

   2023 · github.com · its alternatives →

6. 6
   Using SQL's Turing completeness to build Tetris▲338

   Using SQL's Turing Completeness to Build Tetris. Contribute to nuno-faria/tetris-sql development by creating an account on GitHub.

   2024 · github.com · its alternatives →

7. 7
   ClickHouse-local – a small tool for serverless data analytics▲289

   Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…

   2023 · clickhouse.com · its alternatives →

8. 8
   Inline SQL in any Python program▲26

   🪄 Inline SQL in any Python program. Contribute to ekzhang/inline-sql development by creating an account on GitHub.

   2022 · github.com · its alternatives →

9. 9
   AskEdith▲289

   Never write SQL from scratch again

   2022 · its alternatives →

10. 10
    Translate between dialects and share SQL queries on the browser▲19

    Last year, I wanted to learn a bit about how easy it would be to deploy a python app via web assembly to the browser and decided to make a wrapper around the amazing sqlglot by Toby Mao and the rest of the team. The tool lets you paste in Sql queries and translate them between the available sql dialects in sqlglot. It also gives you parse diagnostics and the ability to easily share queries via storing all the state in the url. The stack that was used is typescript for the UI and pyodide to integrate with Sqlglot, which does the heavy lifting. It's more of a toy app but I've found some use…

    2025 · sqlscope.netlify.app · its alternatives →

11. 11
    Logtail▲246

    Query your logs like you query your database

    2021 · betterstack.com · its alternatives →

12. 12
    Anyquery▲110

    Query anything with SQL (e.g. Notion, GitHub, JSON)

    2024 · anyquery.dev · its alternatives →

13. 13
    PugSQL, a Python Port of HugSQL▲155

    PugSQL is a Python library for interacting with your database the way the gods intended.

    2019 · pugsql.org · its alternatives →

14. 14
    Database Sensei▲83

    Generate arduous database queries in a snap

    2023 · its alternatives →

15. 15DS
    Django SQL Dashboard▲204

    2021 · django-sql-dashboard.datasette.io · its alternatives →

16. 16SQ
    SQLite query inside a Bash function▲134

    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&#x2F;_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 · its alternatives →

17. 17
    sqanything▲89

    Query any data tables on the Web with SQL

    2021 · chromewebstore.google.com · its alternatives →

18. 18SA
    SpreadsheetDB – A database that you can query with spreadsheets▲144

    2017 · spreadsheetdb.io · its alternatives →

19. 19
    sqlTranslate▲94

    sql, data, analytics, database, query, syntax, translation

    2023 · askai.free · its alternatives →

20. 20QW
    QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install▲53

    2023 · play.questdb.io · its alternatives →

21. 21
    UseSQL for Web Scraping▲78

    Extract information from websites using SQL

    2022 · usesql.com · its alternatives →

22. 22
    ThingieQuery▲73

    An Excel plugin that makes using SQL in Excel easy

    2016 · querystorm.com · its alternatives →

23. 23
    SQLtoughAI▲80

    The ultimate personal AI assistant for SQL queries

    2023 · its alternatives →

24. 24RS
    Run SQL on Spreadsheets▲43

    2021 · spanrr.com · its alternatives →

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →