You can create the procedures through IL, instead of table columns create procedures. While creating the procedures there is one option to select the query type. If it is with input parameters change that to post – query, write default values and save. Create IL using the procedure, and refresh the parameters to get the values.