There are several flags which can be provided to Sqlite3 during connection [1]. Alternative libraries such as apsw provide the ability to use these flags [2], however it would be nice if `sqlite3` supported this out of the box.

Is there any reason why the wrapper for `sqlite3` does not allow flags to be passed in? If not, can we add it?

[1]: https://www.sqlite.org/c3ref/open.html
[2]: https://github.com/rogerbinns/apsw/blob/master/example-code.py#L466

It requires switch to the v2 open function of the SQLite C API. While we're at it, we can also enable URI filenames.

URI filename support has been added in f13bb1e40fbc (Python 3.4+).

    db = sqlite3.connect('file:path/to/database?mode=ro', uri=True)

Here is a patch that adds a new flags parameter to sqlite3.connect().

IMO this issue can be closed as the URI filename interface can be used instead of the flags. The URI interface parameters can override the flags given as specified in:
https://www.sqlite.org/c3ref/open.html