Is your feature request related to a problem?
From 3.0.0, calcite engine provides more power to support complex operators such as join. But SQL plugin still leverage coordinator node to run all operators in memory if pushdown doesn't work. So configurable operator limitations are required for that.

What solution would you like?
Add configurable limitations for each high cost operators.

What alternatives have you considered?
Keep as-is and limit by memory monitor.

Do you have any additional context?
Add any other context or screenshots about the feature request here.