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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details
py-sqlglot Easily customizable SQL parser and transpiler
17.16.2_1 databases on this many watch lists=0 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 17.16.2Version 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: 2024-03-23 14:31:10
Commit Hash: 3323b88
Also Listed In: python
License: MIT
WWW:
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.
Homepage    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 py39-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 py39-sqlglot listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py39-sqlglot
Package flavors (<flavor>: <package>)
  • py39: py39-sqlglot
distinfo:
TIMESTAMP = 1693333947 SHA256 (sqlglot-17.16.2.tar.gz) = a3447e81da039e8fd3741ca9021141ae51f6909f1de43c18a93a679160538549 SIZE (sqlglot-17.16.2.tar.gz) = 8562390

Packages (timestamps in pop-ups are UTC):
py39-sqlglot
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest17.16.217.16.2-17.16.217.16.2---
FreeBSD:13:quarterly17.16.217.16.215.2.017.16.217.16.217.16.217.16.217.16.2
FreeBSD:14:latest17.16.217.16.28.0.017.16.217.16.215.0.0-15.0.0
FreeBSD:14:quarterly17.16.217.16.2-17.16.217.16.217.16.217.16.217.16.2
FreeBSD:15:latest17.16.217.16.2n/a17.16.2n/a17.16.217.16.217.16.2
FreeBSD:15:quarterly--n/a-n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py39-setuptools>=0 : devel/py-setuptools@py39
  2. py39-setuptools-scm>=0 : devel/py-setuptools-scm@py39
  3. py39-wheel>=0 : devel/py-wheel@py39
  4. python3.9 : lang/python39
  5. py39-build>=0 : devel/py-build@py39
  6. py39-installer>=0 : devel/py-installer@py39
Test dependencies:
  1. python3.9 : lang/python39
Runtime dependencies:
  1. python3.9 : lang/python39
This port is required by:
for Run
  1. databases/py-mycli

Configuration Options:
No options to configure
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: 33

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
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: 33