| Port details |
- py-shandy-sqlfmt Sqlfmt formats your dbt SQL files so you don't have to
- 0.28.2 devel
 =0      0.27.0Version of this port present on the latest quarterly branch. - Maintainer: ume@FreeBSD.org
- Port Added: 2025-05-31 14:48:05
- Last Update: 2025-11-01 17:23:22
- Commit Hash: 1403bb7
- Also Listed In: python
- License: APACHE20
- WWW:
- https://sqlfmt.com
- https://github.com/tconbeer/sqlfmt
- Description:
- sqlfmt formats your dbt SQL files so you don't have to. It is similar
in nature to black, gofmt, and rustfmt (but for SQL).
sqlfmt promotes collaboration. An auto-formatter makes it easier to
collaborate with your team and solicit contributions from new
people. You will never have to mention (or argue about) code style in
code reviews again.
sqlfmt is fast. Forget about formatting your code, and spend your time
on business logic instead. sqlfmt processes hundreds of files per
second and only operates on files that have changed since the last
run.
sqlfmt works with Jinja. It formats the code that users look at, and
therefore doesn't need to know anything about what happens after the
templates are rendered.
sqlfmt integrates with your workflow. As a CLI written in Python, it's
easy to install locally on any OS and run in CI. Plays well with dbt,
pre-commit, SQLFluff, VSCode, and GitHub Actions. sqlfmt powers the
dbt Cloud IDE's Format button.
sqlfmt is not configurable, except for line length. It enforces a
single style. sqlfmt maintains comments and some extra newlines, but
largely ignores all indentation and line breaks in the input file.
sqlfmt is not a linter. It does not parse your code into an AST; it
just lexes it and tracks a small subset of tokens that impact
formatting. This lets us "do one thing and do it well:" sqlfmt is very
fast, and easier to maintain and extend than linters that need a full
SQL grammar.
For now, sqlfmt only works on select, delete, grant, revoke, and
create function statements (which is all you need if you use sqlfmt
with a dbt project). It is being extended to additional DDL and
DML. Visit this tracking issue for more information.
  ¦  ¦  ¦  ¦ 
- 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}shandy-sqlfmt>0:devel/py-shandy-sqlfmt@${PY_FLAVOR}
- To install the port:
- cd /usr/ports/devel/py-shandy-sqlfmt/ && make install clean
- To add the package, run one of these commands:
- pkg install devel/py-shandy-sqlfmt
- pkg install py311-shandy-sqlfmt
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-shandy-sqlfmt listed in the above command, you can pick from the names under the Packages section.- PKGNAME: py311-shandy-sqlfmt
- Package flavors (<flavor>: <package>)
- py311: py311-shandy-sqlfmt
- distinfo:
- TIMESTAMP = 1761368202
SHA256 (shandy_sqlfmt-0.28.2.tar.gz) = 0a78a2eee23f8b84b19a2895ca4608237d6da19037ce71346417fe01e97bad8b
SIZE (shandy_sqlfmt-0.28.2.tar.gz) = 70725
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-hatchling>=0 : devel/py-hatchling@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:
-
- py311-black>=0 : devel/py-black@py311
- py311-click>=8.0<9.0 : devel/py-click@py311
- py311-Jinja2>=3.0<4.0 : devel/py-Jinja2@py311
- py311-platformdirs>=2.4<5.0 : devel/py-platformdirs@py311
- py311-tqdm>=4.0<5.0 : misc/py-tqdm@py311
- python3.11 : lang/python311
- There are no ports dependent upon this port
Configuration Options:- No options to configure
- Options name:
- devel_py-shandy-sqlfmt
- 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 |
|---|
0.28.2
01 Nov 2025 17:23:22
 |
Matthias Andree (mandree) |
*: Revise USES=python:... version range constraints
and strip all lower bounds of 3.9 or 3.10 because they are implied now.
python:3.9-X -> python:-X
python:3.9+ -> python
python:3.10-X -> python:-X
python:3.10+ -> python
(options such as ,build preserved) |
0.28.2
25 Oct 2025 04:58:31
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: Update to 0.28.2 |
0.28.1
23 Oct 2025 11:14:10
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: Update to 0.28.1 |
0.28.0
18 Oct 2025 08:57:40
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: poetry is not used for build anymore |
0.28.0
18 Oct 2025 08:43:30
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: fix build |
0.28.0
18 Oct 2025 08:32:28
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: Update to 0.28.0 |
0.27.0
02 Sep 2025 17:03:09
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: Update to 0.27.0 |
0.26.0
31 May 2025 14:47:41
|
Hajimu UMEMOTO (ume) |
devel/py-shandy-sqlfmt: correct portname |
As an Amazon Associate I earn from qualifying purchases.