Can we create a data connection of a browser compatible template with Microsoft SQL?
If you want to dynamically query and submit data from a browser form to SQL you need web services.
Here are some that are installable and reusable.
Qdabra Database Accelerator Suite Version 2.1 - Developer