Poor performance SQL generated direct query

[hi_world]

Hello,

In direct query mode on GCP views, we have observed that the generated SQL is not optimal in the sense that it selects all columns from intermediate tables even if we only want to display two columns in the visual.

Thank you very much for your assistance.
Best regards

[lbendlin]

Read about Value.NativeQuery

[hi_world]

Thank you for your reply.
We have already tested and the behavior remains the same.