Fix unescaped {TMP} variables in tests

On Windows {TMP} can return ~, which will result in a parse error

Add pdo_sqlite tests for empty filename and in-memory uri (#7662)

pdo_sqlite already supports empty filenames and shared in-memory DBs. Add tests for them.