sqlite3 does this, so libsql shell should as well. For example:
$ sqlite3 test.db
sqlite> create table t (t text);
sqlite> create view v (t) as select * from t;
sqlite> .schema
CREATE TABLE t (t text);
CREATE VIEW v (t) as select * from t
/* v(t) */;
sqld needs to allow views to be created: https://github.com/libsql/sqld/issues/563
But I suppose it's possible for someone to import a sqlite3 database file that already has views.
sqlite3 does this, so libsql shell should as well. For example:
sqld needs to allow views to be created: https://github.com/libsql/sqld/issues/563 But I suppose it's possible for someone to import a sqlite3 database file that already has views.