DEFAULT VALUES doesn't work on sqlite

[teepark]

Version

1.29.0

What happened?

I had a similar issue as #3781 trying to insert DEFAULT VALUES RETURNING id but getting the same failure as in that issue.

To simplify and try to work around it, I removed the RETURNING clause and changed it to :exec, but still got a similar error.

Relevant log output

line 8:22 no viable alternative at input 'workspace default'
# package 
db/queries/auth.sql:1:1: no viable alternative at input 'workspace default'

Database schema

create table workspace(
	id integer primary key autoincrement
);

create table user(
	id integer primary key autoincrement,
	workspace_id integer not null references workspace(id),
	email text not null,
	passhash text
);
create unique index user_by_email on user(email);

SQL queries

-- name: InsertWorkspace :exec
insert into workspace default values;

Configuration

version: "2"
sql:
- schema: db/migrations
  queries: db/queries
  engine: sqlite
  gen:
    go:
      out: db

Playground URL

No response

What operating system are you using?

macOS

What database engines are you using?

SQLite

What type of code are you generating?

Go

[ororsatti]

So, looking at the parser rules,

insert_stmt:
    with_clause? (
        INSERT_
        | REPLACE_
        | INSERT_ OR_ (
            REPLACE_
            | ROLLBACK_
            | ABORT_
            | FAIL_
            | IGNORE_
        )
    ) INTO_ (schema_name DOT)? table_name (AS_ table_alias)? (
        OPEN_PAR column_name ( COMMA column_name)* CLOSE_PAR
    )? (
        (
            VALUES_ OPEN_PAR expr (COMMA expr)* CLOSE_PAR (
                COMMA OPEN_PAR expr ( COMMA expr)* CLOSE_PAR
            )*
            | select_stmt
        ) upsert_clause? returning_clause?
    )
    | DEFAULT_ VALUES_
;

It seems that the default values is positioned poorly. Should be prob under the upsert clause, example:

```g4
insert_stmt:
    with_clause? (
        INSERT_
        | REPLACE_
        | INSERT_ OR_ (
            REPLACE_
            | ROLLBACK_
            | ABORT_
            | FAIL_
            | IGNORE_
        )
    ) INTO_ (schema_name DOT)? table_name (AS_ table_alias)? (
        OPEN_PAR column_name ( COMMA column_name)* CLOSE_PAR
    )? (
        (
            VALUES_ OPEN_PAR expr (COMMA expr)* CLOSE_PAR (
                COMMA OPEN_PAR expr ( COMMA expr)* CLOSE_PAR
            )*
            | select_stmt
        ) upsert_clause? returning_clause?
        | DEFAULT_ VALUES_
    )
;

It should also handle returning_clause after the default values.

I'll open a PR in the next few days, fixing it.

[ororsatti]

#4002