In the end, as a workaround I had to move/delegate the query to the .NET API backend. From API I can build the query in the exact way I need by previously processing filters, timestamps or versions, ending up with a similar code to the one displayed below:

It would have been much better to make it with a central common Databricks SQL function but not possible so far.

KR