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
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details
py-sqlglotc mypyc-compiled extensions for SQLGlot
30.11.0 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 30.8.0Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-04-18 22:03:36
Last Update: 2026-07-08 13:31:07
Commit Hash: 56bb5c3
Also Listed In: python
License: MIT
WWW:
https://github.com/tobymao/sqlglot/tree/main/sqlglotc
https://github.com/tobymao/sqlglot
Description:
sqlglotc provides an easily customizable SQL parser and transpiler.
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.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}sqlglotc>0:databases/py-sqlglotc@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-sqlglotc/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-sqlglotc
  • pkg install py312-sqlglotc
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 py312-sqlglotc listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-sqlglotc
Package flavors (<flavor>: <package>)
  • py312: py312-sqlglotc
distinfo:
TIMESTAMP = 1782966252 SHA256 (sqlglot-30.11.0.tar.gz) = 1a23c6e2adb41da61fda46b1848d2fa26341d447fc0f0cd5ca21160362100991 SIZE (sqlglot-30.11.0.tar.gz) = 5893125

Expand this list (2 items)

Collapse this list.

SHA256 (sqlglotc-30.11.0.tar.gz) = 6ce71f4d31459df966f3752848f397e254ff5d4e2772594e539e23cff0f2bbc8 SIZE (sqlglotc-30.11.0.tar.gz) = 485462

Collapse this list.

Packages (timestamps in pop-ups are UTC):
py311-sqlglotc
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest30.0.330.0.3--30.0.3n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 

py312-sqlglotc
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest30.8.030.8.0--30.11.0---
FreeBSD:14:quarterly-30.11.0--30.11.0---
FreeBSD:15:latest30.8.030.11.0n/a-n/an/a--
FreeBSD:15:quarterly30.11.030.11.0n/a-n/an/a--
FreeBSD:16:latest30.8.030.11.0n/a-n/an/a--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-setuptools>=61.0 : devel/py-setuptools@py312
  2. py312-setuptools-scm>=0 : devel/py-setuptools-scm@py312
  3. py312-sqlglot-mypy>=2.1.0.post2 : databases/py-sqlglot-mypy@py312
  4. py312-types-python-dateutil>=0 : devel/py-types-python-dateutil@py312
  5. py312-wheel>=0 : devel/py-wheel@py312
  6. python3.12 : lang/python312
  7. py312-build>=0 : devel/py-build@py312
  8. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. python3.12 : lang/python312
Runtime dependencies:
  1. python3.12 : lang/python312
There are no ports dependent upon this port
Configuration Options:
No options to configure
Options name:
databases_py-sqlglotc
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/sqlglotc/
  2. https://pypi.org/packages/source/s/sqlglotc/
Collapse this list.
Port Moves
  • port moved here from databases/py-sqlglotrs on 2026-04-18
    REASON: Remove obsoleted port. Use databases/py-sqlglotc instead

Number of commits found: 3

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
30.11.0
08 Jul 2026 13:31:07
commit hash: 56bb5c31025b18cadf8e4e97ae2c9219b037a85dcommit hash: 56bb5c31025b18cadf8e4e97ae2c9219b037a85dcommit hash: 56bb5c31025b18cadf8e4e97ae2c9219b037a85dcommit hash: 56bb5c31025b18cadf8e4e97ae2c9219b037a85d files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/py-sqlglotc: Update to 30.11.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md
30.8.0
22 May 2026 05:06:40
commit hash: 4980196dfc56b38b46af4409f1633c829011746acommit hash: 4980196dfc56b38b46af4409f1633c829011746acommit hash: 4980196dfc56b38b46af4409f1633c829011746acommit hash: 4980196dfc56b38b46af4409f1633c829011746a files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/py-sqlglotc: Update to 30.8.0

Changes:	https://github.com/tobymao/sqlglot/blob/main/CHANGELOG.md
30.0.3
18 Apr 2026 21:18:18
commit hash: 553e52353d9aa704e4477327c1152eb337e1f18dcommit hash: 553e52353d9aa704e4477327c1152eb337e1f18dcommit hash: 553e52353d9aa704e4477327c1152eb337e1f18dcommit hash: 553e52353d9aa704e4477327c1152eb337e1f18d files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/py-sqlglotc: Add py-sqlglotc 30.0.3

sqlglotc provides an easily customizable SQL parser and transpiler.

Number of commits found: 3
Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
apache-commons-httpclientJul 10
apache-commons-httpclientJul 10
httpclientJul 10
gitlabJul 09
mailpitJul 09
xorg-serverJul 08
xwaylandJul 08
emacsJul 06
emacs-develJul 06
xrdpJul 06
xrdp-develJul 06
zeekJul 06
roundcubeJul 05
weechatJul 05
p5-CGI-SessionJul 04

28 vulnerabilities affecting 437 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2026-07-10 13:37:26 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 34846
Broken 89
Deprecated 280
Ignore 205
Forbidden 0
Restricted 1
No CDROM 1
Vulnerable 45
Expired 19
Set to expire 206
Interactive 0
new 24 hours 15
new 48 hours20
new 7 days127
new fortnight283
new month410
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2026 Dan Langille. All rights reserved.