Skip to main content
# SqlAst

[![Pypi](https://img.shields.io/pypi/v/sqlast.svg?maxAge=600&style=for-the-badge)](https://pypi.python.org/pypi/sqlast)
[![Travis build](https://img.shields.io/travis/Vesuvium/sqlast.svg?maxAge=600&style=for-the-badge)](https://travis-ci.org/Vesuvium/sqlast)
[![Codacy grade](https://img.shields.io/badge/codequality-B-green.svg?style=for-the-badge)](https://app.codacy.com/app/Vesuvium/sqlast)
[![Codacy coverage](https://img.shields.io/badge/coverage-96%25-brightgreen.svg?style=for-the-badge)](https://app.codacy.com/app/Vesuvium/sqlast)

An SQL parser that uses LALR (instead of regex), providing precise, accurate
and complete SQL parsing. SqlAst is meant to be used as library, but a cli is
also provided.

Once the SQL is parsed, is provided as an abstract syntax tree that can be used
to transpile to another language, for example in an SQL to YAML transpiler,
to analyse the sql file, or to write your own SQL interpreter.


## Installing

```sh
pip install sqlast
```

## Usage

```python
from sqlast.App import SqlAst


tree = SqlAst.parse('hello.sql')
print(tree.pretty())
```

### Cli

```sh
sqlast parse hello.sql
```

Metadata

Release files for sqlast 1.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlast 1.0.0
File Size Uploaded Provenance Actions
sqlast-1.0.0.tar.gz 4.2 kB Without provenance Details for sqlast-1.0.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for sqlast 1.0.0
File Interpreter ABI Platform Actions
sqlast-1.0.0-py3-none-any.whl Python 3 none any Details for sqlast-1.0.0-py3-none-any.whl

Total release size: 10.1 kB

Release files / sqlast-1.0.0.tar.gz

Download URL sqlast-1.0.0.tar.gz
Size 4.2 kB
Tags Source
SHA-256 checksum
How to use checksums
37006f93f457f0954f61315fac4623cc58ebed0a44c4ebb1fa7b74d205069aa0
BLAKE2b-256 checksum
How to use checksums
81d63bd8356f13668deef3d1c8708fb09a11a094e5376e2a05171cbc8aff7154
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via Python-urllib/3.6

Release files / sqlast-1.0.0-py3-none-any.whl

Download URL sqlast-1.0.0-py3-none-any.whl
Size 5.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
e414b81c3199f7b359c7e226899731ec41cbadbdf5f3f3c672596402487dbbe1
BLAKE2b-256 checksum
How to use checksums
eddcf1983e55f03e9482c9d9567a0111072aa14a34234840a07a460c52049b88
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via Python-urllib/3.6

Security for sqlast 1.0.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page