Invalid parameters on scheduled query date range

[DEZwak]

Issue Summary

Any time there is a date range parameter on query, the error message appears in the log/email alerts like this

Unable to update hash for query # because of invalid parameters: The following parameter values are incompatible with their definitions: date_range
Could not enqueue query # due to InvalidParameterError('The following parameter values are incompatible with their definitions: date_range')

The data itself seemingly still refreshes correctly, but we get email spammed/the log grows when we have a bunch of queries with date range parameters. This is possibly related to #6683

Steps to Reproduce

1. Make a query with a date range parameter (preferably a dynamic one like "Last 7 Days"):

SELECT
   *
FROM
	table
WHERE
 "date" >= '{{ date_range.start }}' AND "date" < '{{ date_range.end }}'
GROUP BY
    "date"

2. Watch logs as it complains that the date_range is invalid.

I did notice from upgrading from v10.1.0 up to v26.3 that I got the same message when running any migration upgrades.

Technical details:

• Redash Version: v26.3.0
• Browser/OS: Ubuntu 24.04
• How did you install Redash: Docker Compose from git pull and migrated v10 database over/upgraded

[DEZwak]

Since the date-range parameter can be stored as an object (with a start/end keys) OR a dynamic string, I've changed _is_date_range in redash/models/parameterized_query.py to be like this for now:

def _is_date_range(obj):
    if isinstance(obj, dict):
        return _is_date(obj.get("start")) and _is_date(obj.get("end"))

    presets = {
        'd_this_week', 'd_this_month', 'd_this_year',
        'd_last_week', 'd_last_month', 'd_last_year',
        'd_last_7_days', 'd_last_14_days', 'd_last_30_days',
        'd_last_60_days', 'd_last_90_days', 'd_last_12_months',
        'd_last_2_years', 'd_last_3_years', 'd_last_10_years',
        'd_today'
    }

    return isinstance(obj, str) and obj in presets

and it seems to have silenced the error, though I wonder if this is correct long-term.

EDIT: Well it silenced the errors, but it made queries have a blank parameter/different error, reverting