Hi , Thanks for reaching out to Microsoft Q&A.
Seems it's not supported, and the workaround will be to use temp tables instead. To not duplicate the answer, I am providing the link below, which was already answered by kranthipakala for a similar question. Pls go through and let me know if this helped.
Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.