I have used REST a lot with NODE. Calling Node FROM Aware not in reverse.
A few suggestions:
1) GET POSTMAN! This lets you very easily with a GUI create REST calls and see the return. Use it, Love it. This way you are only debugging the Aware part of this.
2). While there are 4 main verbs, they mostly have to do with how and what is being sent to the REST client. There is NOTHING wrong with using a POST to delete. Since you will have a named rest process. It can do whatever you want. Since, unless you are issuing a GET, your only response is usally a msg stating Success of Failure.
3). Use the best tool for the job. While there are a lot of plus in many cases having Aware hosting your rest backend. It is pretty simple to set up a node server (Express, Restify, etc.) and use that if you are just manipulating SQL.)
Bruce