Port details |
- py-sqlglot Easily customizable SQL parser and transpiler
- 26.10.1 databases
=2 25.34.1Version of this port present on the latest quarterly branch. - Maintainer: sunpoet@FreeBSD.org
 - Port Added: 2022-09-04 03:54:32
- Last Update: 2025-03-19 03:38:22
- Commit Hash: 85bddf0
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
- Also Listed In: python
- License: MIT
- WWW:
- https://sqlglot.com/sqlglot.html
- https://github.com/tobymao/sqlglot
- 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.
 ¦ ¦ ¦ ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - There is no configure plist information for this port.
- Dependency lines:
-
- ${PYTHON_PKGNAMEPREFIX}sqlglot>0:databases/py-sqlglot@${PY_FLAVOR}
- To install the port:
- cd /usr/ports/databases/py-sqlglot/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/py-sqlglot
- pkg install py311-sqlglot
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py311-sqlglot listed in the above command, you can pick from the names under the Packages section.- PKGNAME: py311-sqlglot
- Package flavors (<flavor>: <package>)
- distinfo:
- TIMESTAMP = 1742070324
SHA256 (sqlglot-26.10.1.tar.gz) = ac6e4f7113f2b308acd904a9063a23bc1719a1cdc37279fc760eeb97d386985e
SIZE (sqlglot-26.10.1.tar.gz) = 5334132
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- py311-setuptools>=61.0 : devel/py-setuptools@py311
- py311-setuptools-scm>=0 : devel/py-setuptools-scm@py311
- py311-wheel>=0 : devel/py-wheel@py311
- python3.11 : lang/python311
- py311-build>=0 : devel/py-build@py311
- py311-installer>=0 : devel/py-installer@py311
- Test dependencies:
-
- python3.11 : lang/python311
- Runtime dependencies:
-
- python3.11 : lang/python311
- This port is required by:
- for Run
-
- databases/py-mycli
- databases/py-sqlframe
Configuration Options:
- ===> The following configuration options are available for py311-sqlglot-26.10.1:
RS=off: SQL parser and transpiler in Rust
===> Use 'make config' to modify these settings
- Options name:
- databases_py-sqlglot
- USES:
- python
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
26.10.1 19 Mar 2025 03:38:22
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.10.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
26.7.0 14 Mar 2025 09:54:12
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.7.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
26.6.0 17 Feb 2025 20:50:52
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.6.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
26.4.1 07 Feb 2025 21:15:59
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.4.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
26.3.9 03 Feb 2025 15:51:01
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.3.9
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
26.0.1 31 Dec 2024 15:47:59
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 26.0.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.34.1 25 Dec 2024 19:15:18
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.34.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.31.4 27 Nov 2024 02:33:33
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.31.4
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.31.2 22 Nov 2024 06:22:15
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.31.2
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.31.0 21 Nov 2024 20:53:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.31.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.30.0 21 Nov 2024 13:38:03
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.30.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.28.0 29 Oct 2024 14:38:33
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.28.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.27.0 26 Oct 2024 23:26:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.27.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.26.0 26 Oct 2024 06:00:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.26.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.25.1 21 Oct 2024 09:17:29
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.25.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.24.5 14 Oct 2024 05:25:25
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.24.5
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.24.0 07 Oct 2024 14:16:43
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.24.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.22.0 30 Sep 2024 13:36:28
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.22.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.21.3 25 Sep 2024 04:22:29
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.21.3
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.20.1 18 Sep 2024 06:13:11
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Add RS option |
25.20.1 15 Sep 2024 20:09:42
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.20.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.19.0 08 Sep 2024 18:37:15
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.19.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.11.0 05 Sep 2024 06:17:54
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.11.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.9.0 15 Aug 2024 10:55:34
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.9.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.8.1 04 Aug 2024 17:14:02
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.8.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.7.1 29 Jul 2024 12:39:28
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.7.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.6.1 21 Jul 2024 09:56:48
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.6.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.6.0 18 Jul 2024 16:46:00
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.6.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
25.5.1 10 Jul 2024 04:57:43
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 25.5.1
- Update WWW
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.16.2_1 23 Mar 2024 14:31:10
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Convert to USE_PYTHON=pep517
- Bump PORTREVISION for package change |
17.16.2 29 Feb 2024 07:18:32
    |
Charlie Li (vishwin)  |
devel/py-setuptools-scm: update to 8.0.4
Directory and PORTNAME changed to match normalised name in release
tarball; consumers updated to match.
Although setuptools itself is specified as a run dependency in the
Python package metadata, it is currently left out here to prevent
environment pollution until at least PR 270510 is committed.
Additionally, this version of setuptools-scm requires setuptools>=61,
which means this version is only meant for USE_PYTHON=pep517 ports
as all USE_PYTHON=distutils ports will switch to devel/py-setuptools58
also after PR 270510. science/py-emmet-core is switched to
devel/py-setuptools_scm7 accordingly, as it specifies setuptools-scm<8.
devel/py-{flit-scm,hatch-vcs} have ${PY_SETUPTOOLS} added to
RUN_DEPENDS to compensate.
Further details: https://wiki.freebsd.org/Python/setuptools
Reported by: yuri
Co-authored by: matthew
Exp-run by: antoine (earlier iteration)
Approved by: yuri (science/py-emmet-core, previous iteration)
PR: 272134
Differential Revision: https://reviews.freebsd.org/D39288 |
17.16.2 04 Sep 2023 09:04:48
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.16.2
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.15.1 26 Aug 2023 20:34:12
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.15.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.15.0 26 Aug 2023 09:27:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.15.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.14.2 21 Aug 2023 17:03:45
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.14.2
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.7.0 16 Aug 2023 18:25:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.7.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.4.1 31 Jul 2023 16:39:56
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.4.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
17.3.0 09 Jul 2023 21:34:28
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 17.3.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
16.7.0 09 Jul 2023 10:18:43
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 16.7.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
15.2.0 30 Jun 2023 07:03:05
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 15.2.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
15.0.0 27 Jun 2023 19:34:34
    |
Rene Ladan (rene)  |
all: remove explicit versions in USES=python for "3.x+"
The logic in USES=python will automatically convert this to 3.8+ by
itself.
Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.
finance/quickfix: mark BROKEN with PYTHON
libtool: compile: c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
^~~~~~~~~~
1 warning and 1 error generated.
Reviewed by: portmgr, vishwin, yuri
Differential Revision: <https://reviews.freebsd.org/D40568> |
15.0.0 05 Jun 2023 21:07:48
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 15.0.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
14.1.1 05 Jun 2023 18:47:00
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 14.1.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
14.1.0 27 May 2023 23:43:51
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 14.1.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
12.2.1 27 May 2023 04:08:22
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 12.2.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
12.1.0 07 May 2023 21:13:26
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 12.1.0
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
11.0.1 21 Mar 2023 19:20:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 11.0.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md
https://github.com/tobymao/sqlglot/commits/main |
10.5.9 05 Feb 2023 15:47:51
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 10.5.9
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md
https://github.com/tobymao/sqlglot/commits/main |
10.5.1 30 Jan 2023 12:59:36
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 10.5.1
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md
https://github.com/tobymao/sqlglot/commits/main |
8.0.0 11 Jan 2023 15:58:34
    |
Dmitry Marakasov (amdmi3)  |
*/*: rename CHEESESHOP to PYPI in MASTER_SITES
PR: 267994
Differential revision: D37518
Approved by: bapt |
8.0.0 30 Dec 2022 09:04:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.3.3
Changes: https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md |
6.3.5 19 Nov 2022 08:11:54
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.3.3
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.3.1 09 Oct 2022 19:45:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.3.1
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.2.7 09 Oct 2022 15:37:53
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.2.7
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.2.6 03 Oct 2022 17:10:26
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.2.6
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.0.7 03 Oct 2022 02:14:47
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.0.7
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.0.4 10 Sep 2022 18:11:12
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.0.4
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.0.2 10 Sep 2022 16:06:11
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.0.2
Changes: https://github.com/tobymao/sqlglot/commits/main |
6.0.0 10 Sep 2022 13:02:42
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Update to 6.0.0
Changes: https://github.com/tobymao/sqlglot/commits/main |
07 Sep 2022 21:58:51
    |
Stefan Eßer (se)  |
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner) |
5.3.1 07 Sep 2022 21:10:59
    |
Stefan Eßer (se)  |
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above ) |
5.3.1 04 Sep 2022 03:41:28
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlglot: Add py-sqlglot 5.3.1
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.
WWW: https://github.com/tobymao/sqlglot |