I have a query that looks something like the following:
SELECT
//Some rows to select
FROM Table
LEFT JOIN (
SELECT
//Some rows from TableA
FROM TableA
WHERE TableA.StartDate BETWEEN {{StartDate}} AND {{EndDate}}
) AS SubqueryA
ON Table.A_id = TableA._id
LEFT JOIN (
SELECT
//Some rows from TableB
FROM TableB
WHERE TableB.UpdatedAt BETWEEN {{StartDate}} AND {{EndDate}}
) AS SubqueryB
ON Table.B_id = TableB._id
While this functions, I'd like to have a DateRange like used with field filters with a rolling default date range on multiple columns. I was looking around and couldn't find anything on the docs.
Could anyone point me to any good solutions or feature request pages? I couldn't manage to find much related to this