sqlparse VS pg_query

Compare sqlparse vs pg_query and see what are their differences.

sqlparse

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

pg_query

Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser (by pganalyze)
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
sqlparse pg_query
7 1
3,557 743
- 0.9%
8.2 6.3
1 day ago 21 days ago
Python C
BSD 3-clause "New" or "Revised" License BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

sqlparse

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.

pg_query

Posts with mentions or reviews of pg_query. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-10-08.

What are some alternatives?

When comparing sqlparse and pg_query you can also consider the following projects:

zetasql - ZetaSQL - Analyzer Framework for SQL

pyparsing - Python library for creating PEG parsers [Moved to: https://github.com/pyparsing/pyparsing]

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

PLY - Python Lex-Yacc

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

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

Pygments

python-user-agents - A Python library that provides an easy way to identify devices like mobile phones, tablets and their capabilities by parsing (browser) user agent strings.

ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.

ijson

Python Left-Right Parser - Python Parser

phonenumbers - Python port of Google's libphonenumber