Can Wappler handle MSSQL store procedures and how about advanced queries?

So, I’m trying to move away from Dreamweaver and have a question in relation to MSSQL Store Procedures and advanced queries.

Can Wappler handle MSSQL Store Procedures? If it can, how do I perform these actions?

How do I perform advanced queries, especially when I need to add CASE as in the example below?

SELECT CASE tblHi5.intApprovedRejectStatus
           WHEN 0
           THEN 'Declined'
           WHEN 1
           THEN 'Approved'
           WHEN 999
           THEN 'Purged'
           ELSE 'Awaiting decision'
       END AS intApprovedRejectStatus
FROM tblHi5
     INNER JOIN tblEmployees ON tblHi5.intEmployeeID = tblEmployees.intEmployeeID
     INNER JOIN tblEmployees AS tblEmployees_1 ON tblHi5.intIssuerID = tblEmployees_1.intEmployeeID
WHERE(tblEmployees_1.intCompanyID = varintCompanyID);

Any info would be great.
Thanks,
Ray.