@RMG - Thank you for your reply.
Custom and Dynamic SQL works.
We have existing implementations which are using built-in adapter templates. We would like to do some property tweak or so and make sure there won’t be any issues with the existing ones. We have changed some of the tables to synonyms, which doesn’t impact the existing implementation, but if we try to change any of the existing adapter template (say SELECT template) which is using a synonym rather than table, we were not able to see the synonym. So, i have to update the template to point to right connection with DB where the actual table exists. Which we are trying to avoid as we might have many templates in this situation.