If I pass raw SQL string to dataframe do I still get the Spark SQL optimizations?

[kant kodali]

HI All,

I am wondering If I pass a raw SQL string to dataframe do I still get the
Spark SQL optimizations? why or why not?

Thanks!