parse failure with CREATE TABLE main.TableName

[bradfitz]

sqlite lets you create a table main.Foo

https://www.sqlite.org/lang_attach.html says:

The schema-names 'main' and 'temp' refer to the main database and the database used for temporary tables. The main and temp databases cannot be attached or detached.

Tables in an attached database can be referred to using the syntax schema-name.table-name. If the name of the table is unique across all attached databases and the main and temp databases, then the schema-name prefix is not required.

Example:

% sqlite3
SQLite version 3.43.2 2023-10-10 13:08:14
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table main.bar (x integer);
sqlite> create table foo.bar (x integer);
Parse error: unknown database foo
  create table foo.bar (x integer);
               ^--- error here
sqlite> 

But this repo wants just an identifier: see https://go.dev/play/p/5TiIUqNTy3W for an error:

	p := sql.NewParser(strings.NewReader("CREATE TABLE main.T1 (C1 TEXT PRIMARY KEY, C2 INTEGER)"))
	_, err := p.ParseStatement()
	if err != nil {
		t.Logf("error: %v", err)
	}

=>

=== RUN   TestCreateTableDot
    prog_test.go:14: error: 1:18: expected AS or left paren, found '.'
--- PASS: TestCreateTableDot (0.00s)
PASS