Can we use Query Folding in Direct Query mode.

Some of the most common transformation that support query folding are:

• Removing or renaming columns
• Merging foldable queries that are based on the same source.
• Appending foldable queries based on the same source.
• Numeric calculations
• Joins
• Pivot and unpivot

The transformations that do not support query folding include:

• Merging or appending queries that are based on different sources.
  • Using some functions while adding custom columns that do not have a counterpart in SQL.
  • Adding columns with complex logic. These refer to functions that do not have equivalent functions in the data source.

The rule of thumb that I use : is or possible to do this opération in SQL ? If yes then low chance to break m'y query folding