SQLLAB Error while running Time Functions in Superset meta database

[medhinishetty]

While querying superset meta DB in SQLLAB, I get an error while using the Time Function
error: superset error: SQL error: no such function: TO_TIMESTAMP

How to reproduce the bug

1. Query Superset meta database using time function: now(), date_part(),make_interval, and interval functions

Expected results

time function: now(), date_part(),make_interval, and interval functions should provide results while using Superset Meta DB

Actual results

Getting this error while using Time functions

Superset metadatabase Error
superset error: SQL error: no such function: now

Screenshots

while using superset meta DB

while using actual PostgreSQL database in sqllab and this is post it does not give the error

Environment

• browser type and version: Chrome
• superset version: 3.1.0rc4
• python version: Python 3.9.17
• node.js version: node -v
• any feature flags active: ENABLE_SUPERSET_META_DB

[G0m3e]

I have the same issue on superset 3.1.1

[michael-s-molina]

This feature was introduced in #14225. Reading the PR description, it uses the shillelagh library which is based on database adaptors. If you need to execute Postgres functions, it seems you need a Postgres adaptor. Correct me if I'm wrong @betodealmeida.

I'm closing this issue as it looks like this should be reported on shillelagh's repo. Please reopen if that's not the case.

[mdeshmu]

@betodealmeida we already pyscopg2 adapter installed. Does shillelagh need anything additional?
Is this issue related to superset or shillelagh?