git: dede8a40cffc - main - databases/sq: Add new port

From: Jimmy Olgeni <olgeni_at_FreeBSD.org>
Date: Wed, 09 Jul 2025 07:25:46 UTC
The branch main has been updated by olgeni:

URL: https://cgit.FreeBSD.org/ports/commit/?id=dede8a40cffc3fea8ec06def0583fa2e04907072

commit dede8a40cffc3fea8ec06def0583fa2e04907072
Author:     Jimmy Olgeni <olgeni@FreeBSD.org>
AuthorDate: 2025-07-09 07:00:31 +0000
Commit:     Jimmy Olgeni <olgeni@FreeBSD.org>
CommitDate: 2025-07-09 07:25:19 +0000

    databases/sq: Add new port
    
    sq is a command-line tool that provides jq-style access to structured
    data sources including SQL databases and document formats. It supports
    cross-source joins, multiple output formats, and unified querying across
    various data sources.
    
    WWW: https://sq.io/
---
 databases/Makefile     |  1 +
 databases/sq/Makefile  | 22 ++++++++++++++++++++++
 databases/sq/distinfo  |  7 +++++++
 databases/sq/pkg-descr | 14 ++++++++++++++
 4 files changed, 44 insertions(+)

diff --git a/databases/Makefile b/databases/Makefile
index ce29492a0960..c076df5d6f2d 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -1076,6 +1076,7 @@
     SUBDIR += spatialite-tools
     SUBDIR += spatialite_gui
     SUBDIR += speedtables
+    SUBDIR += sq
     SUBDIR += sql-workbench
     SUBDIR += sqlcached
     SUBDIR += sqlcipher
diff --git a/databases/sq/Makefile b/databases/sq/Makefile
new file mode 100644
index 000000000000..d3079f072817
--- /dev/null
+++ b/databases/sq/Makefile
@@ -0,0 +1,22 @@
+PORTNAME=	sq
+DISTVERSIONPREFIX=	v
+DISTVERSION=	0.48.5
+CATEGORIES=	databases
+
+MAINTAINER=	olgeni@FreeBSD.org
+COMMENT=	CLI tool for querying multiple databases and data formats
+WWW=		https://sq.io/
+
+LICENSE=	MIT
+LICENSE_FILE=	${WRKSRC}/LICENSE
+
+USES=		go:modules
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	neilotoole
+
+GO_MODULE=	github.com/neilotoole/sq
+
+PLIST_FILES=	bin/sq
+
+.include <bsd.port.mk>
diff --git a/databases/sq/distinfo b/databases/sq/distinfo
new file mode 100644
index 000000000000..7e7470620471
--- /dev/null
+++ b/databases/sq/distinfo
@@ -0,0 +1,7 @@
+TIMESTAMP = 1752020539
+SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.mod) = 438cd2aa3b98e2401dfab7e002b37c6f9d3bb861cfe43a87ac9c77da97abfed3
+SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.mod) = 4051
+SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.zip) = 1ba7cf722a5678b789dff9d6f22ffc47435b1c328c5dd7d91ef049ed6b66136f
+SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.zip) = 63203565
+SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/neilotoole-sq-v0.48.5_GH0.tar.gz) = 4ed9cef836e66174b6e01c8d410cd393aeae7f7069a428a7ab2adcd1e282cf68
+SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/neilotoole-sq-v0.48.5_GH0.tar.gz) = 62450246
diff --git a/databases/sq/pkg-descr b/databases/sq/pkg-descr
new file mode 100644
index 000000000000..7871ea0d080e
--- /dev/null
+++ b/databases/sq/pkg-descr
@@ -0,0 +1,14 @@
+sq is a command-line tool that provides jq-style access to structured data
+sources including SQL databases and document formats like CSV, Excel, and JSON.
+
+Key features:
+
+- Query multiple database types (PostgreSQL, MySQL, SQLite, SQL Server, etc.)
+- Cross-source joins between different databases and file formats
+- Multiple output formats (JSON, CSV, Excel, HTML, XML, Markdown)
+- Database inspection and schema comparison
+- SQL execution with syntax highlighting
+- Data import/export between sources
+
+sq simplifies working with structured data by providing a unified interface
+for querying and transforming data across various sources.