Hi @Shubhanshu Dubey , welcome to Microsoft Q&A forum.
To query multiple azure sql databases, currently we have to use elastic queries or external tables. If there were blob storage we were reading from we could have used openrowset function but this is not the case with your requirement I think.
Could you please tell us if there is any restrictions to use elastic query, also and where are you going to use this data?