databases/py-sqlglot 30.12.0
Easily customizable SQL parser and transpiler
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
d94ea4b5ec- License
- MIT
- Categories
- databases, python
- Package size
- 1456.3 KiB, 10089.9 KiB installed
Description
SQLGlot is a no dependency Python SQL parser, transpiler, and optimizer. It can be used to format SQL or translate between different dialects like DuckDB, Presto, Spark, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically correct SQL in the targeted dialects.
It is a very comprehensive generic SQL parser with a robust test suite. It is also quite performant while being written purely in Python.
You can easily customize the parser, analyze queries, traverse expression trees, and programmatically build SQL.
Syntax errors are highlighted and dialect incompatibilities can warn or raise depending on configurations.
Install
As a binary package — by origin, or by package name:
pkg install databases/py-sqlglot
pkg install py312-sqlglotFrom the ports tree:
cd /usr/ports/databases/py-sqlglot/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= py312-sqlglot>0:databases/py-sqlglotPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 30.12.0 | 30.12.0 | 8.0.0 | 27.3.1 | 30.12.0 |
| FreeBSD:14:quarterly | 30.12.0 | 30.12.0 | n/a | 26.31.0 | 30.12.0 |
| FreeBSD:15:latest | 30.12.0 | 30.12.0 | n/a | 27.3.1 | 27.3.1 |
| FreeBSD:15:quarterly | 30.12.0 | 30.12.0 | n/a | n/a | n/a |
| FreeBSD:16:latest | 30.12.0 | 30.12.0 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Build 3
${PYTHON_PKGNAMEPREFIX}setuptools>=61.0: devel/py-setuptools${PYTHON_PKGNAMEPREFIX}setuptools-scm>=0: devel/py-setuptools-scm${PYTHON_PKGNAMEPREFIX}wheel>=0: devel/py-wheel
The full lists below include those, and their dependencies in turn.
All build dependencies 17
All run dependencies 7
Configuration
Options name: databases_sqlglot
| Option | Default | Description |
|---|---|---|
| C | on | SQL parser and transpiler in C |
- USES
- python
- Service scripts
- none
Files
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlglot-30.12.0.tar.gz | 5.90511e+06 | 6b8369704662d4f654bc934cea4dd31c916c2a571b389210cb9e951a275e5fd9 |
Master sites 1
- PYPI