Add option/flag for translating query into "inefficient" query

### What problem are you trying to solve?

We could introduce per-query option/flag to allow "inefficient" translations. Currently when the translation is likely a pit of failure (like duplicating complex expressions), we don't do the translation. In some cases users might want to opt into having the query translated, instead of going all the way to the other side and using raw SQL or similar. Because it's an opt-in, by default everything will be the same.

### Describe the solution you'd like

_No response_