[sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

Hi. Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "value cannot be null". CREATE TABLE [test] ( [Id] ROWID NOT NULL, [Name] nvarchar(50) NOT NULL, [Value] nvarchar(256) NOT NULL ); INSERT INTO test

[sqlite] Feature Request: PRAGMA foreign_key_list(tableName) should display the name of the foreign key constraint

Hi. Thank you for sqlite3. I would like to request that "PRAGMA foreign_key_list(tableName)" display the name of the foreign key constraint. For example, For the following table schemas: create table artist(artistid integer primary key, artistname text); create table track(trackid integer,