I can use url like http://ip_port/ords/table/?q={“id”:111} to query db by “id=111”,
but I don’t know how to query max(id), and is there any way to query by entire SQL(such as select …from table_name)?

I try a lot of times by changing the param in url, but it does not work.
I don’t know much about the mechanism inside, because the API was configured by a colleague and I just use it. My feeling is that it needs to be configured before it can provide flexible API functions.
I hope someone can answer my question and provide some suggestions.