Skip to main content

An SQL parser that uses LALR for sql parsing

Project description

# 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
```

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlast-0.1.3.tar.gz (4.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sqlast-0.1.3-py3-none-any.whl (5.8 kB view details)

Uploaded Python 3

File details

Details for the file sqlast-0.1.3.tar.gz.

File metadata

  • Download URL: sqlast-0.1.3.tar.gz
  • Upload date:
  • Size: 4.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: Python-urllib/3.6

File hashes

Hashes for sqlast-0.1.3.tar.gz
Algorithm Hash digest
SHA256 1b951588246cba43cf871e2550414b506ea708a99347879c7d7edfa3b4c00365
MD5 5046e94ea9556271fa59d3cce1cbb249
BLAKE2b-256 4e61d3dcd968e82c2b52625093830bb0e87507bd26fde9881f47bcc8d8b26d97

See more details on using hashes here.

File details

Details for the file sqlast-0.1.3-py3-none-any.whl.

File metadata

  • Download URL: sqlast-0.1.3-py3-none-any.whl
  • Upload date:
  • Size: 5.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: Python-urllib/3.6

File hashes

Hashes for sqlast-0.1.3-py3-none-any.whl
Algorithm Hash digest
SHA256 2d5b6b91c61fc22842e1684fe622b10ef9950f33df93a48c69e5db0df7fa5ac5
MD5 865e29c9b8f0085924f498bd28b52ed5
BLAKE2b-256 5b3cea7752645d34632375cf9138225d01dd99db5eb1ab6f37afbd1a31e6b5d1

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page