As of version 3.36.0, the following gives an error: > ~~~~ CREATE TABLE b(id); CREATE VIEW bv AS SELECT * FROM b; SELECT rowid FROM bv; -- Error, as of version 3.36.0 ~~~~ This is due to [check-in a2ddb89b206c1387](src:/info/a2ddb89b206c1387) on [2021-04-07](src:/timeline?c=a2ddb89b206c1387). The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is provided for legacy code that needs bug compatibility.