If you can connect to SQLserver from Python, then yes Prodigy lets you pass in a custom Database class via the "db" setting returned by a custom recipe, or via an entry point of your own Python package installed in the same environment.
See this thread for more details and discussion:
You can find the expected database API in your PRODIGY_README.html.