[SQL] Optimize expensive filters by pulling expensive operations into a prior map #6815

This is particularly beneficial for expensive temporal filters, which get rewritten into complex subplans.
This will enable computing common operations only once, and will enable better pruning of unused fields.