databases/py-sqlglot30.12.0

databases/py-sqlglot: Update to 25.11.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.9.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.8.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.7.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.6.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.6.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 25.5.1

- Update WWW

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Convert to USE_PYTHON=pep517

- Bump PORTREVISION for package change

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

databases/py-sqlglot: Update to 17.16.2

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.15.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.15.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.14.2

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.7.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.4.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 17.3.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 16.7.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 15.2.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

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>

databases/py-sqlglot: Update to 15.0.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 14.1.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 14.1.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 12.2.1

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 12.1.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

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

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

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

*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt

databases/py-sqlglot: Update to 6.3.3

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md

databases/py-sqlglot: Update to 6.3.3

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.3.1

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.2.7

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.2.6

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.0.7

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.0.4

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.0.2

Changes:	https://github.com/tobymao/sqlglot/commits/main

databases/py-sqlglot: Update to 6.0.0

Changes:	https://github.com/tobymao/sqlglot/commits/main

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)

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.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)

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