A Web search for SQL Server API leads to lots of hits on how to access SQL Server with a REST interface, which in AI2 would typically be done using the Web component.
(You would be the first.)
This would be a great learning opportunity for you.
For AI2 Web API samples, see