templates query not quoted

[thisismygitrepo]

Describe the bug

When clicking (+) on table in database, a simple select statement populates a cell, which is nice, however, it fails to run because pgsql, timescaledb and many many other databases are case sensitive. Can you guys please surround the table name and the schema with quotes? that should solve it and every other db is happy with it too.
PS: this also fix a massive range of other problems related to nameing (e.g. if table has a space in its name or it has a special chacarcter etc).

Please make it like SELECT * FROM "SCHEMA_NAME"."TABLE_NAME" LIMIT 100.

Will you submit a PR?

• Yes

Environment

󰕈 24.4.0 noble 󱆃 ➜ uvx marimo env
{
"marimo": "0.17.0",
"editable": false,
"location": "/home/alex/.cache/uv/archive-v0/f96v7QZbERElKNL7VOj3u/lib/python3.14/site-packages/marimo",
"OS": "Linux",
"OS Version": "6.6.87.2-microsoft-standard-WSL2",
"Processor": "x86_64",
"Python Version": "3.14.0",
"Locale": "C",
"Binaries": {
"Browser": "--",
"Node": "v24.10.0"
},
"Dependencies": {
"click": "8.3.0",
"docutils": "0.22.2",
"itsdangerous": "2.2.0",
"jedi": "0.19.2",
"markdown": "3.9",
"narwhals": "2.9.0",
"packaging": "25.0",
"psutil": "7.1.1",
"pygments": "2.19.2",
"pymdown-extensions": "10.16.1",
"pyyaml": "6.0.3",
"starlette": "0.48.0",
"tomlkit": "0.13.3",
"typing-extensions": "4.15.0",
"uvicorn": "0.38.0",
"websockets": "15.0.1"
},
"Optional Dependencies": {},
"Experimental Flags": {}
}

Code to reproduce

No response

[Light2Dark]

Strange, is that the correct table name (streamStatus)? Why is the error showing lowercase. I think if we quoted it, postgres would enforce the case sensitivity.

cmiiw, unquoted names are case insensitive: https://stackoverflow.com/questions/20878932/are-postgresql-column-names-case-sensitive

[Light2Dark]

oh sorry, i misread, SELECT * FROM "TABLE_NAME"."SCHEMA_NAME" is this a normal postgres database? I thought it would be schema first, then table.
SCHEMA_NAME.TABLE_NAME

[thisismygitrepo]

@Light2Dark of course, schema then table.
fixed
sorry and thanks.
donno why the bot closed the case.

[Light2Dark]

Ah sorry accidentally closed. I have a feeling it's a deeper issue, by default postgres is case-insensitiv so schema_name.table_name should work unless the name is just wrong..

[thisismygitrepo]

Its actually timescaledb a variant on top of pgsql.
hope that helps.

[thisismygitrepo]

I just ran test again.
shows the full picture with and without quotes.

(btw, I read docs and you are right, its only case sensitive when we quote things, but why does it not work unless we quote things?)

[thisismygitrepo]

I just wanted to say that this has nothing to do with marimo, I can confirm same behaviour with every other connector and engine of pgsql, they all want it quoted, hence the title I started with this bug.

[Light2Dark]

It might be the timescale db sql flavour.
If you wrote raw python, it should fail too I think.

from sqlalchemy import create_engine, text

# Create an engine to connect to your database
engine = create_engine('...')

# Establish a connection
with engine.connect() as connection:
    # Execute a raw SQL statement
    result = connection.execute(text("SELECT * FROM ..."))

maybe we can generate different code based on the dialect, we had another request for MS-SQL. Big query also handles it differently. We can let the community maintain the code gen too.