notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
py-sqlglot Easily customizable SQL parser and transpiler
26.10.1 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 25.34.1Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
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.
HomepageHomepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

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>)
  • py311: py311-sqlglot
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):
py39-sqlglot
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--15.2.0--17.16.217.16.217.16.2
FreeBSD:14:latest--8.0.0--15.0.0-15.0.0
FreeBSD:14:quarterly-----17.16.217.16.217.16.2
FreeBSD:15:latest--n/a-n/a17.16.217.16.217.16.2
 

py311-sqlglot
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest26.7.026.7.0-26.7.026.10.1---
FreeBSD:13:quarterly26.0.126.0.1-26.0.126.0.1---
FreeBSD:14:latest26.6.026.10.1-26.6.026.10.1---
FreeBSD:14:quarterly26.0.126.0.1-26.0.126.0.1---
FreeBSD:15:latest26.6.026.10.1n/a26.6.0n/a---
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools>=61.0 : devel/py-setuptools@py311
  2. py311-setuptools-scm>=0 : devel/py-setuptools-scm@py311
  3. py311-wheel>=0 : devel/py-wheel@py311
  4. python3.11 : lang/python311
  5. py311-build>=0 : devel/py-build@py311
  6. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. python3.11 : lang/python311
This port is required by:
for Run
  1. databases/py-mycli
  2. 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:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/s/sqlglot/
  2. https://pypi.org/packages/source/s/sqlglot/
Collapse this list.

Number of commits found: 62

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
26.10.1
19 Mar 2025 03:38:22
commit hash: 85bddf02b9d61068f661de8aa1fe0aa72065b27bcommit hash: 85bddf02b9d61068f661de8aa1fe0aa72065b27bcommit hash: 85bddf02b9d61068f661de8aa1fe0aa72065b27bcommit hash: 85bddf02b9d61068f661de8aa1fe0aa72065b27b files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: ad67228d85a642cb4860f9aad6786f8bd6815d99commit hash: ad67228d85a642cb4860f9aad6786f8bd6815d99commit hash: ad67228d85a642cb4860f9aad6786f8bd6815d99commit hash: ad67228d85a642cb4860f9aad6786f8bd6815d99 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 0817013333b11bc6681c66ea2c46b2cc61ea49c6commit hash: 0817013333b11bc6681c66ea2c46b2cc61ea49c6commit hash: 0817013333b11bc6681c66ea2c46b2cc61ea49c6commit hash: 0817013333b11bc6681c66ea2c46b2cc61ea49c6 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 69b9368cf6e88dc5f4618b290cfca2807e998dbdcommit hash: 69b9368cf6e88dc5f4618b290cfca2807e998dbdcommit hash: 69b9368cf6e88dc5f4618b290cfca2807e998dbdcommit hash: 69b9368cf6e88dc5f4618b290cfca2807e998dbd files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 87d460741d70096fbff7a8aa1470056b19fb41a6commit hash: 87d460741d70096fbff7a8aa1470056b19fb41a6commit hash: 87d460741d70096fbff7a8aa1470056b19fb41a6commit hash: 87d460741d70096fbff7a8aa1470056b19fb41a6 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 85f1ebc93479b7fa5860dd113323df3ed43ab560commit hash: 85f1ebc93479b7fa5860dd113323df3ed43ab560commit hash: 85f1ebc93479b7fa5860dd113323df3ed43ab560commit hash: 85f1ebc93479b7fa5860dd113323df3ed43ab560 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: c94ebd909687c88a3455afb11adaf610815deb6ccommit hash: c94ebd909687c88a3455afb11adaf610815deb6ccommit hash: c94ebd909687c88a3455afb11adaf610815deb6ccommit hash: c94ebd909687c88a3455afb11adaf610815deb6c files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 4c7485d18021aebe0568cd8d7620a025be8e837ccommit hash: 4c7485d18021aebe0568cd8d7620a025be8e837ccommit hash: 4c7485d18021aebe0568cd8d7620a025be8e837ccommit hash: 4c7485d18021aebe0568cd8d7620a025be8e837c files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 7e13377a02a2d8f4a7f70f4000cfdbc7a967e636commit hash: 7e13377a02a2d8f4a7f70f4000cfdbc7a967e636commit hash: 7e13377a02a2d8f4a7f70f4000cfdbc7a967e636commit hash: 7e13377a02a2d8f4a7f70f4000cfdbc7a967e636 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 35a65a45930399a1aed9afdfc02d3659542ff82dcommit hash: 35a65a45930399a1aed9afdfc02d3659542ff82dcommit hash: 35a65a45930399a1aed9afdfc02d3659542ff82dcommit hash: 35a65a45930399a1aed9afdfc02d3659542ff82d files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: f1ee88bd5a22b2f27ff25b8a75f1aa8804da2248commit hash: f1ee88bd5a22b2f27ff25b8a75f1aa8804da2248commit hash: f1ee88bd5a22b2f27ff25b8a75f1aa8804da2248commit hash: f1ee88bd5a22b2f27ff25b8a75f1aa8804da2248 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: f5bf986199321db153519812a3c5629c0b907783commit hash: f5bf986199321db153519812a3c5629c0b907783commit hash: f5bf986199321db153519812a3c5629c0b907783commit hash: f5bf986199321db153519812a3c5629c0b907783 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 557215d97a50c438711e69d2637b261d2da46035commit hash: 557215d97a50c438711e69d2637b261d2da46035commit hash: 557215d97a50c438711e69d2637b261d2da46035commit hash: 557215d97a50c438711e69d2637b261d2da46035 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 85b93ac3c98b22f980a243fbb3678fbd4b89146acommit hash: 85b93ac3c98b22f980a243fbb3678fbd4b89146acommit hash: 85b93ac3c98b22f980a243fbb3678fbd4b89146acommit hash: 85b93ac3c98b22f980a243fbb3678fbd4b89146a files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 9ece77f5df5416296d18e5a49e1f82337a5fabe9commit hash: 9ece77f5df5416296d18e5a49e1f82337a5fabe9commit hash: 9ece77f5df5416296d18e5a49e1f82337a5fabe9commit hash: 9ece77f5df5416296d18e5a49e1f82337a5fabe9 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: fff5dccea9e12b3f20b37af3f017f4da6a4c0696commit hash: fff5dccea9e12b3f20b37af3f017f4da6a4c0696commit hash: fff5dccea9e12b3f20b37af3f017f4da6a4c0696commit hash: fff5dccea9e12b3f20b37af3f017f4da6a4c0696 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 354b25f630bb551052179f14b0fb65680b7a3a1dcommit hash: 354b25f630bb551052179f14b0fb65680b7a3a1dcommit hash: 354b25f630bb551052179f14b0fb65680b7a3a1dcommit hash: 354b25f630bb551052179f14b0fb65680b7a3a1d files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 2e393c11752a099932beda6ba4a1590e7de08ebdcommit hash: 2e393c11752a099932beda6ba4a1590e7de08ebdcommit hash: 2e393c11752a099932beda6ba4a1590e7de08ebdcommit hash: 2e393c11752a099932beda6ba4a1590e7de08ebd files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: e031e823be1e76cabc6e0f7fcb7127a773e6762ecommit hash: e031e823be1e76cabc6e0f7fcb7127a773e6762ecommit hash: e031e823be1e76cabc6e0f7fcb7127a773e6762ecommit hash: e031e823be1e76cabc6e0f7fcb7127a773e6762e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 78f52cb3b8e296896a35983b546dfeae4205560ecommit hash: 78f52cb3b8e296896a35983b546dfeae4205560ecommit hash: 78f52cb3b8e296896a35983b546dfeae4205560ecommit hash: 78f52cb3b8e296896a35983b546dfeae4205560e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-sqlglot: Add RS option
25.20.1
15 Sep 2024 20:09:42
commit hash: 55d3569a95b3eb1f785056ec465e4278f622c5b7commit hash: 55d3569a95b3eb1f785056ec465e4278f622c5b7commit hash: 55d3569a95b3eb1f785056ec465e4278f622c5b7commit hash: 55d3569a95b3eb1f785056ec465e4278f622c5b7 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 0bc5e22dc6190469986768af2d0849f114b8a988commit hash: 0bc5e22dc6190469986768af2d0849f114b8a988commit hash: 0bc5e22dc6190469986768af2d0849f114b8a988commit hash: 0bc5e22dc6190469986768af2d0849f114b8a988 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: c91230d1b45ea65cfb7b3e01704947e18b9849d4commit hash: c91230d1b45ea65cfb7b3e01704947e18b9849d4commit hash: c91230d1b45ea65cfb7b3e01704947e18b9849d4commit hash: c91230d1b45ea65cfb7b3e01704947e18b9849d4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: f2ca253fec43580451bf1dd81e5ba6d134857acccommit hash: f2ca253fec43580451bf1dd81e5ba6d134857acccommit hash: f2ca253fec43580451bf1dd81e5ba6d134857acccommit hash: f2ca253fec43580451bf1dd81e5ba6d134857acc files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: ba7f3a54464b4520addb658b66ede5430790de63commit hash: ba7f3a54464b4520addb658b66ede5430790de63commit hash: ba7f3a54464b4520addb658b66ede5430790de63commit hash: ba7f3a54464b4520addb658b66ede5430790de63 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: fd5a0f225ecc44fa7c8c1446a22c17db52b3d174commit hash: fd5a0f225ecc44fa7c8c1446a22c17db52b3d174commit hash: fd5a0f225ecc44fa7c8c1446a22c17db52b3d174commit hash: fd5a0f225ecc44fa7c8c1446a22c17db52b3d174 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: ffaf14978fecb9a184ee5cdec26d9300919f113ecommit hash: ffaf14978fecb9a184ee5cdec26d9300919f113ecommit hash: ffaf14978fecb9a184ee5cdec26d9300919f113ecommit hash: ffaf14978fecb9a184ee5cdec26d9300919f113e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 97e3904d35bd003d3803cbae1e71db3bc1324ad8commit hash: 97e3904d35bd003d3803cbae1e71db3bc1324ad8commit hash: 97e3904d35bd003d3803cbae1e71db3bc1324ad8commit hash: 97e3904d35bd003d3803cbae1e71db3bc1324ad8 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 807ed4b0a0635e834a7370b3a2fd27767dbf4faacommit hash: 807ed4b0a0635e834a7370b3a2fd27767dbf4faacommit hash: 807ed4b0a0635e834a7370b3a2fd27767dbf4faacommit hash: 807ed4b0a0635e834a7370b3a2fd27767dbf4faa files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 3323b88378a70234b127be544bc26f7f7f3e2201commit hash: 3323b88378a70234b127be544bc26f7f7f3e2201commit hash: 3323b88378a70234b127be544bc26f7f7f3e2201commit hash: 3323b88378a70234b127be544bc26f7f7f3e2201 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-sqlglot: Convert to USE_PYTHON=pep517

- Bump PORTREVISION for package change
17.16.2
29 Feb 2024 07:18:32
commit hash: 5d4139f8bdb67bd6e8328422f9762661bd0d6454commit hash: 5d4139f8bdb67bd6e8328422f9762661bd0d6454commit hash: 5d4139f8bdb67bd6e8328422f9762661bd0d6454commit hash: 5d4139f8bdb67bd6e8328422f9762661bd0d6454 files touched by this commit
Charlie Li (vishwin) search for other commits by this committer
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
commit hash: 9ea28a4706cd1053113ef280cbac526fb9fb1d88commit hash: 9ea28a4706cd1053113ef280cbac526fb9fb1d88commit hash: 9ea28a4706cd1053113ef280cbac526fb9fb1d88commit hash: 9ea28a4706cd1053113ef280cbac526fb9fb1d88 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 7d1e7d20298e4bc7fa00c38ff316d49be5e03d94commit hash: 7d1e7d20298e4bc7fa00c38ff316d49be5e03d94commit hash: 7d1e7d20298e4bc7fa00c38ff316d49be5e03d94commit hash: 7d1e7d20298e4bc7fa00c38ff316d49be5e03d94 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 54205c60413a90add4a006366fcc5af049232392commit hash: 54205c60413a90add4a006366fcc5af049232392commit hash: 54205c60413a90add4a006366fcc5af049232392commit hash: 54205c60413a90add4a006366fcc5af049232392 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 95bedbdbec7f051477585eda8af4a423a8730b3fcommit hash: 95bedbdbec7f051477585eda8af4a423a8730b3fcommit hash: 95bedbdbec7f051477585eda8af4a423a8730b3fcommit hash: 95bedbdbec7f051477585eda8af4a423a8730b3f files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 60a8ebcbbfb48b46d752cf9a1829927deecb1acbcommit hash: 60a8ebcbbfb48b46d752cf9a1829927deecb1acbcommit hash: 60a8ebcbbfb48b46d752cf9a1829927deecb1acbcommit hash: 60a8ebcbbfb48b46d752cf9a1829927deecb1acb files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 01ed82388c4e8f3c612e0fb4631be4a382b15981commit hash: 01ed82388c4e8f3c612e0fb4631be4a382b15981commit hash: 01ed82388c4e8f3c612e0fb4631be4a382b15981commit hash: 01ed82388c4e8f3c612e0fb4631be4a382b15981 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 3808bb17816ba61bccde933f7d4708c3be83edb1commit hash: 3808bb17816ba61bccde933f7d4708c3be83edb1commit hash: 3808bb17816ba61bccde933f7d4708c3be83edb1commit hash: 3808bb17816ba61bccde933f7d4708c3be83edb1 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 6fb771ddc9b39bcb7253a324c1304bbc480563cecommit hash: 6fb771ddc9b39bcb7253a324c1304bbc480563cecommit hash: 6fb771ddc9b39bcb7253a324c1304bbc480563cecommit hash: 6fb771ddc9b39bcb7253a324c1304bbc480563ce files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 5829e9db9af81eae55e2008bd1ee58f017ce2020commit hash: 5829e9db9af81eae55e2008bd1ee58f017ce2020commit hash: 5829e9db9af81eae55e2008bd1ee58f017ce2020commit hash: 5829e9db9af81eae55e2008bd1ee58f017ce2020 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacb files touched by this commit
Rene Ladan (rene) search for other commits by this committer
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
commit hash: 76d32836de8d53e0e685f8ec89a78b8056e491c4commit hash: 76d32836de8d53e0e685f8ec89a78b8056e491c4commit hash: 76d32836de8d53e0e685f8ec89a78b8056e491c4commit hash: 76d32836de8d53e0e685f8ec89a78b8056e491c4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 33bcfb14268c15089a462ea66f62130c2ce46191commit hash: 33bcfb14268c15089a462ea66f62130c2ce46191commit hash: 33bcfb14268c15089a462ea66f62130c2ce46191commit hash: 33bcfb14268c15089a462ea66f62130c2ce46191 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 106120b274c03ebe1b5183d8f82351d624d8f9f1commit hash: 106120b274c03ebe1b5183d8f82351d624d8f9f1commit hash: 106120b274c03ebe1b5183d8f82351d624d8f9f1commit hash: 106120b274c03ebe1b5183d8f82351d624d8f9f1 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 7b94ba5f89c8940f94e1333280a17742d88c3e4bcommit hash: 7b94ba5f89c8940f94e1333280a17742d88c3e4bcommit hash: 7b94ba5f89c8940f94e1333280a17742d88c3e4bcommit hash: 7b94ba5f89c8940f94e1333280a17742d88c3e4b files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 338bfda473fc3590da18de0214d4a7be774d95c4commit hash: 338bfda473fc3590da18de0214d4a7be774d95c4commit hash: 338bfda473fc3590da18de0214d4a7be774d95c4commit hash: 338bfda473fc3590da18de0214d4a7be774d95c4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 1f9117cc99cd9c3ead469398244bec4ceba051cacommit hash: 1f9117cc99cd9c3ead469398244bec4ceba051cacommit hash: 1f9117cc99cd9c3ead469398244bec4ceba051cacommit hash: 1f9117cc99cd9c3ead469398244bec4ceba051ca files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: e55a580b4efac99ed788b645af574ed04fc44422commit hash: e55a580b4efac99ed788b645af574ed04fc44422commit hash: e55a580b4efac99ed788b645af574ed04fc44422commit hash: e55a580b4efac99ed788b645af574ed04fc44422 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: a3a98ba8d82f804980a86f9716957be9a519035dcommit hash: a3a98ba8d82f804980a86f9716957be9a519035dcommit hash: a3a98ba8d82f804980a86f9716957be9a519035dcommit hash: a3a98ba8d82f804980a86f9716957be9a519035d files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656 files touched by this commit
Dmitry Marakasov (amdmi3) search for other commits by this committer
*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt
8.0.0
30 Dec 2022 09:04:27
commit hash: 4bf0838a2aaeb20acf7e6dcdb727e222cae1ccb4commit hash: 4bf0838a2aaeb20acf7e6dcdb727e222cae1ccb4commit hash: 4bf0838a2aaeb20acf7e6dcdb727e222cae1ccb4commit hash: 4bf0838a2aaeb20acf7e6dcdb727e222cae1ccb4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 5aed3aee35924c5058c0ef8c7ebe0b8d2bca49f7commit hash: 5aed3aee35924c5058c0ef8c7ebe0b8d2bca49f7commit hash: 5aed3aee35924c5058c0ef8c7ebe0b8d2bca49f7commit hash: 5aed3aee35924c5058c0ef8c7ebe0b8d2bca49f7 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 6d0ec9e9cd3f84063500ee3b0f01a63e516d769ecommit hash: 6d0ec9e9cd3f84063500ee3b0f01a63e516d769ecommit hash: 6d0ec9e9cd3f84063500ee3b0f01a63e516d769ecommit hash: 6d0ec9e9cd3f84063500ee3b0f01a63e516d769e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 217fef811e8aca7b80db37df75b632df6782e63bcommit hash: 217fef811e8aca7b80db37df75b632df6782e63bcommit hash: 217fef811e8aca7b80db37df75b632df6782e63bcommit hash: 217fef811e8aca7b80db37df75b632df6782e63b files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: e4848d177ae2a221a6d736fcd81ae8e6fc51ab1dcommit hash: e4848d177ae2a221a6d736fcd81ae8e6fc51ab1dcommit hash: e4848d177ae2a221a6d736fcd81ae8e6fc51ab1dcommit hash: e4848d177ae2a221a6d736fcd81ae8e6fc51ab1d files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: eec9ce48380f025ae039dae2110f067529b6f2c4commit hash: eec9ce48380f025ae039dae2110f067529b6f2c4commit hash: eec9ce48380f025ae039dae2110f067529b6f2c4commit hash: eec9ce48380f025ae039dae2110f067529b6f2c4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: d7f397e63015b3847f5b63214678452612f11c53commit hash: d7f397e63015b3847f5b63214678452612f11c53commit hash: d7f397e63015b3847f5b63214678452612f11c53commit hash: d7f397e63015b3847f5b63214678452612f11c53 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: 155aac9fc365b9a235ebcb0213e7c23762cae83acommit hash: 155aac9fc365b9a235ebcb0213e7c23762cae83acommit hash: 155aac9fc365b9a235ebcb0213e7c23762cae83acommit hash: 155aac9fc365b9a235ebcb0213e7c23762cae83a files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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
commit hash: ecc673d3a9aeac5c475049b78b25f009bba122c4commit hash: ecc673d3a9aeac5c475049b78b25f009bba122c4commit hash: ecc673d3a9aeac5c475049b78b25f009bba122c4commit hash: ecc673d3a9aeac5c475049b78b25f009bba122c4 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-sqlglot: Update to 6.0.0

Changes:	https://github.com/tobymao/sqlglot/commits/main
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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 View all of this commit message)
5.3.1
04 Sep 2022 03:41:28
commit hash: 757662b297a6a0e64b3d823e83484df6af8ffc13commit hash: 757662b297a6a0e64b3d823e83484df6af8ffc13commit hash: 757662b297a6a0e64b3d823e83484df6af8ffc13commit hash: 757662b297a6a0e64b3d823e83484df6af8ffc13 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
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

Number of commits found: 62