Thanks @QFabian for your suggestion. Issue I am facing is not with query parameters or getting not all records. I am able to get the output but output is showing as one single array of record. I am looking forward to split all the fields rather just like below,
Was wondering if SQL Select needs to be enhanced to handle nested JSON output but not sure how.