[NFR] SQLite Dialect Implementation

Provides the implementation of the stub method (wherever appropriate) plus changes `view.schema` to `schema.view` for CREATE/DROP VIEW statements.