sqlparse

A non-validating SQL parser module for Python (by andialbrecht)

Sqlparse Alternatives

Similar projects and alternatives to sqlparse

  1. Mermaid

    101 sqlparse VS Mermaid

    Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.

  2. Judoscale

    Save 47% on cloud hosting with autoscaling that just works. Judoscale integrates with Django, FastAPI, Celery, and RQ to make autoscaling easy and reliable. Save big, and say goodbye to request timeouts and backed-up task queues.

    Judoscale logo
  3. sqlfluff

    35 sqlparse VS sqlfluff

    A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

  4. spark-joy

    39 sqlparse VS spark-joy

    ✨😂 2000+ ways to add design flair, user delight, and whimsy to your product.

  5. grammars-v4

    Grammars written for ANTLR v4; expectation that the grammars are free of actions.

  6. go-mysql-server

    A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.

  7. zetasql

    ZetaSQL - Analyzer Framework for SQL

  8. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  9. libpg_query

    C library for accessing the PostgreSQL parser outside of the server environment

  10. dagre

    10 sqlparse VS dagre

    Directed graph layout for JavaScript

  11. PLY

    3 sqlparse VS PLY

    Python Lex-Yacc

  12. pyparsing

    0 sqlparse VS pyparsing

    Discontinued Python library for creating PEG parsers [Moved to: https://github.com/pyparsing/pyparsing] (by pyparsing)

  13. JSqlParser

    JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

  14. rhizome

    A JIT for Ruby, implemented in pure Ruby

  15. ijson

    0 sqlparse VS ijson
  16. swifties

    a custom language construction kit

  17. alasql

    5 sqlparse VS alasql

    AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

  18. Lark

    35 sqlparse VS Lark

    Lark is a parsing toolkit for Python, built with a focus on ergonomics, performance and modularity.

  19. parser

    A MySQL Compatible SQL Parser (by pingcap)

  20. InfluxDB

    InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better sqlparse alternative or higher similarity.

sqlparse discussion

Log in or Post with

sqlparse reviews and mentions

Posts with mentions or reviews of sqlparse. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-06-08.
  • Show HN: Databasediagram.com – Private, Text to Entity-Relationship Diagram Tool
    7 projects | news.ycombinator.com | 8 Jun 2023
    Suggest checking out the sqlparse library for a way to do the different flavours without needing to address each case directly: https://github.com/andialbrecht/sqlparse
  • Data Load Diagram
    2 projects | /r/dataengineering | 6 Mar 2023
    Gotcha, since we haven't actually written all of this yet I don't have any useful code snippets to share but we've discussed tackling the problem internally using something like sqlparse. You'd need to identify the relevant sql chunks, parse them for table dependency information and then create the relevant entities in whichever data lineage tool you were using.
  • This Week In Python
    5 projects | dev.to | 16 Sep 2022
    sqlparse – A non-validating SQL parser module for Python
  • Open Source SQL Parsers
    17 projects | dev.to | 8 Oct 2021
    Regular expressions is a popular approach to extract information from SQL statements. However, regular expressions quickly become too complex to handle common features like WITH, sub-queries, windows clauses, aliases and quotes. sqlparse is a popular python package that uses regular expressions to parse SQL.
  • Automated SQL formatting checks
    2 projects | /r/dataengineering | 27 Sep 2021
    This one is not bad: https://github.com/andialbrecht/sqlparse.
  • Let's write a compiler, part 5: A code generator
    14 projects | news.ycombinator.com | 19 Aug 2021
  • BigQuery Lineage
    1 project | /r/bigquery | 7 May 2021
    We used this repo for this: https://github.com/andialbrecht/sqlparse. I may have miscommunicated. We didn't write the parser from scratch, we created a way for the parser to detect downstream and upstream dependencies of the resource.
  • A note from our sponsor - InfluxDB
    influxdata.com | 24 Apr 2025
    Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems. Learn more →

Stats

Basic sqlparse repo stats
7
3,856
7.6
2 months ago

Sponsored
Save 47% on cloud hosting with autoscaling that just works
Judoscale integrates with Django, FastAPI, Celery, and RQ to make autoscaling easy and reliable. Save big, and say goodbye to request timeouts and backed-up task queues.
judoscale.com

Did you know that Python is
the 2nd most popular programming language
based on number of references?