Returning after Insert statement not parsing in sqlite

[earthboundkid]

What would you like to see?

If I have more than one statement in a .sql file, sqruff only lints the first statement.

Checked issues

• I have checked this request in the issues.

[gvozdvmozgu]

Could you please provide an example of the SQL query and the configuration, if available? The issue is likely with the parser.

[earthboundkid]

.sqruff

[sqruff]
dialect = sqlite
rules = all

[sqruff:indentation]
indent_unit = space
tab_space_size = 2
indented_joins = True

[sqlfluff:rules:capitalisation.keywords]
# Keywords
capitalisation_policy = upper
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.identifiers]
# Unquoted identifiers
extended_capitalisation_policy = lower
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.functions]
# Function names
extended_capitalisation_policy = lower
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.literals]
# Null & Boolean Literals
capitalisation_policy = upper

comment.sql

-- name: CreateComment :one
INSERT INTO
comment (
  name, contact, subject, cc, message, ip, user_agent, referrer, host_page
)
VALUES
(
  ?, ?, ?, ?, ?, ?, ?, ?, ?
)
RETURNING * ;

-- name: ListComments :many
SELECT *
FROM comment
ORDER BY modified_at DESC
LIMIT ?
OFFSET ? ;

If I swap the statements, it unindents the insert columns and question marks.

[benfdking]

I'm sorry, but I've renamed this because the issue is not quite what you've said.

The error is two-fold:

1. We don't parse the following syntaxes yet RETURNING *.
2. Your statements are not valid SQL that's why in parts it's struggling. ? isn't valid SQL. You're looking for the placeholder templater

-- name: CreateComment :one
INSERT INTO
comment (
  name, contact, subject, cc, message, ip, user_agent, referrer, host_page
)
VALUES
(
  ?, ?, ?, ?, ?, ?, ?, ?, ?
);

-- name: ListComments :many
SELECT *
FROM comment
ORDER BY modified_at DESC
LIMIT ?
OFFSET ?;

[sqruff]
dialect = sqlite
rules = all
templater = placeholder

[sqruff:templater:placeholder]
param_style = question_mark

[sqruff:indentation]
indent_unit = space
tab_space_size = 2
indented_joins = True

[sqlfluff:rules:capitalisation.keywords]
# Keywords
capitalisation_policy = upper
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.identifiers]
# Unquoted identifiers
extended_capitalisation_policy = lower
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.functions]
# Function names
extended_capitalisation_policy = lower
# Comma separated list of words to ignore for this rule
ignore_words = None
ignore_words_regex = None

[sqlfluff:rules:capitalisation.literals]
# Null & Boolean Literals
capitalisation_policy = upper

[earthboundkid]

In that case, it seems like a bug if it thinks the syntax is invalid but it doesn’t return an error.