Re: Shell Feature Request: spaces before dot commands
On Wed Mar 04, 2020 at 12:44:09PM +0000, Simon Slavin wrote:
> On 4 Mar 2020, at 12:19pm, [hidden email] wrote:
> > I like to sometimes indent a block of SQL and change
> > settings or run dot commands within a transaction, e.g.:
> > BEGIN
> > .mode csv
> > .import ...
> > COMMIT;
> Dot commands are not SQL commands, they are instructions to the shell
> application. Transactions, CASE structures, WITH structures, and
> other such things do not affect them.
Well commands like .import create a table. Since SQLite supports
transactional DDL there is certainly a relevance between BEGIN/COMMIT
and a call to .import, no?
But that is all kind of beside my point: I do not see a technical
necessity for dot commands to have no leading space, and my programming
experience would be better of without that requirement.