Run SQL queries on CSV files and SharePoint lists from the command line
Run standard SQL statements against flat files and cloud lists: SELECT, UPDATE, INSERT, and DELETE against CSV files or SharePoint Lists using an interactive REPL or scripts. xql (Excelano Query Language) by David M. Anderson targets data analysts, system administrators, and developers who need scriptable, portable access to tabular data. Key capabilities include Microsoft Graph SharePoint connectivity, server-side OData filtering, row previews before writes, and multiple export formats for pipelines or reporting.
What does xql let you do with non-database tabular data?
xql lets you use standard SQL grammar to query and modify CSV files and SharePoint Lists, accepting SELECT, UPDATE, INSERT, and DELETE statements. It treats each CSV or SharePoint list like a relational table and outputs results as ASCII tables, CSV, TSV, or JSON. The tool runs as a single portable binary with zero external dependencies, so it integrates into scripts and automated pipelines without needing a database engine.
Does xql impact system or network performance during large queries?
Server-side filtering reduces network transfer for SharePoint because xql translates WHERE clauses into OData filters sent via Microsoft Graph, which moves filtering to the server. For local CSV workloads, the binary operates on local files directly; the distribution as a single executable avoids launching heavyweight environments. These design choices limit unnecessary data transfer and keep operations bounded to the files or lists you target.
Is it safe to run destructive statements like UPDATE or DELETE?
xql enforces a preview-before-commit workflow by showing a sample of affected rows and requiring explicit confirmation before performing writes back to a source file or a SharePoint list. This write-safety model prevents accidental bulk changes during interactive sessions and scripts that include destructive statements. The interactive REPL also offers command history and auto-completion for cautious exploration.
Do I need technical knowledge to operate xql effectively?
Command-line and SQL familiarity are required because the tool expects users to write SQL and operate a REPL. The interactive shell provides conveniences such as history and completion, which ease exploratory tasks, but the primary audience remains data analysts, sysadmins, and developers who already work with SQL or scripting in automation workflows.
Practical judgment for scriptable tabular data management
xql suits technical users who need reproducible, scriptable SQL access to CSV files and SharePoint Lists, particularly when server-side filtering and a preview workflow reduce risk. Expect a command-line, SQL-driven interaction model rather than a graphical editor; that trade-off gives precise control but requires SQL competence from the operator.
