Treat sqlite cli commands as comments

[kmerfeld]

What would you like to see?

Currently this doesn't parse sqlite's cli commands.
https://sqlite.org/cli.html#special_commands_to_sqlite3_dot_commands_

I tend to have a scratch.sql file around that I treat like a repl.

it will often look like

.mode table
.headers ON
.nullvalue NULL

select name, title from a inner join b on a.title = b.title where b.field = 'data'

when the cli commands are included, the sql gets formatted as

select name,
title from a inner join b on a.title = b.title where b.field = 'data'

without them, it gets formatted as

select
    name,
    title
from a
inner join b on a.title = b.title
where b.field = 'data'

Ideally sqruff would just treat the cli commands as comments

Checked issues

• I have checked this request in the issues.

[benfdking]

Hi @kmerfeld,

Thanks for trying the tool and for filing the request!

While we can envisage this as a feature based on templaters that hides the statements from the linter before it considers them, we currently see this request as slightly outside the scope of the project, and we don't really have the capacity to do it.

We're happy to support any contributions though.