SQLite isn't a database so much as a file format with a handy API, so it should be expected it won't have all of the feature you may expect from a full database

SQLite isn't a database so much as a file format with a handy API, so it should be expected it won't have all of the feature you may expect from a full database engine. It doesn't support users and permissions for example. I don't think a features presence in SQLite can be seen as indicative of the feature set of any other database software.