Get JSON from a Rest GET call from a stored SQL query or function?

So I cannot use any of the SDK packages, I need to send and recieve data to the tables via rest only. I've managed to get Authorization working, that was fun lol now I'd like to do a simple test where I simply SELECT * FROM testtable, but it must be via rest with auth headers.

Is this possible?!