Transforming Editor to SQL questions make static date filter out of relative date filter

Get Help
1

Hello,

we are very happy Metabase users for years! A lot of people in our organization use the Editor to build a question for a certain topic and then use the "View the SQL" button to look up the SQL so they can use the SQL in different tools/processes.

In the past the following worked: filtering the question by e.g. "current month" would return a SQL containing = DATE_TRUNC("month", CAST(CURRENT_TIMESTAMP() AS timestamp).
But since a couple of weeks this returns the static date of when the query is triggered: = CAST('2024-10-01 00:00:00+02:00' AS TIMESTAMP).

We are running on a self hosted version 0.49.12 (after v50.27 had to be rolled back) and haven't done an update since end of May. However, people are only reporting this issue since about a month. Did someone experience anything similar? Is there something obvious that I am missing on how this can be fixed?

Any help appreciated!

2

so we made that to enhance the caching on some databases (passing runtime functions to the engine busted the cache), why is it a problem?

3

Thanks for your response. The "problem" ist that many users in our organization who do not have any SQL knowledge need certain SQL queries for other no-code tools etc. That is why they create a Metabase question via the Editor and then look up the SQL behind it to copy the SQL code and use it somewhere else. This has been super helpful for a lot of people across all teams.