SBarnes wrote: I also noticed that the Stored Procedures and Views made the cut as well into JiwaServiceModel, which means pretty all reporting data functionality is available is there any plans to include the database functions as well being generated by the templates?
SQL functions are not supported for strong typing, so no - nothing regarding SQL functions will be included. That's doesn't stop you from using them in ad-hoc queries, you just don't get the pleasantries like you do with stored procedures or tables.
I made an
article on how to call a stored procedure within the REST API, but it would apply to use inside plugins also - I haven't spent much time exploring the optimal way to get results from a stored procedure, so if my article is lacking in any way let me know and we can get that updated.