Hello @Shreyansh Jarged,
Welcome to the MS Q&A platform.
The output clause is not currently supported in Synapse.
Output clause currently applies to on-prem SQL, Azure SQL DB, and Azure SQL managed instances.
I would recommend submitting feature request feedback for the output clause in the synapse IDEAS forum: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c
All the feedback shared in this forum is actively monitored and reviewed by the Synapse engineering team, who will prioritize them based on the number of requests.
Also, please share the link once the feedback is posted so that we can pass the feedback to respective product owners for further review.
I hope this info helps.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.