[Bug]: (some?) SQLite functions are available to Source Queries, but aren't available to Inline Queries

[jamietanna]

Describe the bug

When trying to use an Inline Query with SQLite, I note that it's not possible to use i.e. julianday.

For instance this works with an sqlite3 shell:

sqlite> select julianday('2023-04-05');
julianday('2023-04-05')
-----------------------
2460039.5    

But fails when using an Inline Query:

select julianday('2023-04-05');

Which results in:

Catalog Error: Scalar Function with name julianday does not exist! Did you mean "julian"? LINE 2: SELECT * FROM (select julianday('2023-04-05') ^

Steps to Reproduce

Write an Inline Query:

select julianday('2023-04-05');

Logs

System Info

Severity

annoyance

Additional Information, or Workarounds

I think this is most likely down to (via):

Evidence runs markdown code fences as SQL queries. These queries use the DuckDB dialect.

[archiewood]

This is intended behaviour.

Inline queries use DuckDB syntax - they are executed in the browser by the DuckDB wasm engine.