TINYSPARQL-SQL(1)

🌸 NAME 🌸

okay bestie, this is TINYSPARQL-SQL(1) from the TinySPARQL manual — the moment where we use SQL to query the TinySPARQL databases 💅✨

🦋 SYNOPSIS 🦋

tinysparql sql -q <sql> | -f <file>

🎀 DESCRIPTION 🎀

So this command literally lets you probe the current database 👀. When you use commands like tinysparql sparql, the SPARQL used is translated into SQL before being run on the database. That means this command lets you use the database directly with SQL and avoid the SPARQL engine entirely — iconic behavior tbh 🔥.

The caller can run a query two ways, bestie:

• by providing a file with the query, or
• by providing a string with the sql query.

The file argument can be either a local path or a URI. It also does not have to be an absolute path. Slay for flexibility 🫶.

✨ OPTIONS ✨

• -f, --file=<file> — Use a file with SPARQL content to query. Don’t forget to end all queries with a semicolon (;) and also to use quotes around table names. The quotes are important because most tables are named after ontology classes like "nfo:Document" and queries will fail without the quotes. This is highkey essential, don’t skip the quotes 💀.
• -q, --query=<sql> — Use a sql string to query the database with.

🌈 EXAMPLES 🌈

Show first 10 "nfo:Document" entries where the TOC is not NULL:

$ tinysparql sql -q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;'

🔗 SEE ALSO 🔗

• tinysparql-sparql(1)
• tinysparql-info(1)
• http://en.wikipedia.org/wiki/SQL

---

mwah 💋 this page is version 3.12.0, dated 09/15/2026, and it’s literally TINYSPARQL-SQL(1) — periodt 💜