SQL Server Stored Procedures

I’m a database consultant looking for a tool to let me build front-ends more easily, and Wappler sounds like a great option. But I deal with complex databases and write a lot of stored procedures in TSQL (MS SQL Server). Can I get an update on the current status of support for these? If I use them to return a result set, am I limited in how I can work with it? Can I get return parameters as well as give it input parameters? Any other limitations I should be aware of?