Some SQL queries not working in Fabric Notebook

[Fabricator]

I noticed some SQL queries are not working in Fabric Notebook when using the %%sql magic. For example UNPIVOT.

Does anyone know why this is and what is the best way around it?

[v-nikhilan-msft]

Hi @Fabricator 
Thanks for using Fabric Community.
Can you please give more details regarding the error, the screenshot of the code and the error message?
These details will help me in understanding the issue better.

Thanks.

[v-nikhilan-msft]

Hi @Fabricator 
We haven’t heard from you on the last response and was just checking back to see if you could share the details asked above. In case if you have any resolution, please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks

[v-nikhilan-msft]

Hi @Fabricator 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .If you have any question relating to the current thread, please do let us know and we will try out best to help you.
Thanks