REST API to extract database table

Summary:

Hi Community,

I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like 
SELECT * FROM PO_HEADERS_ALL

I came across that REST APIs are designed for business objects (e.g., Suppliers), but I wanted to check if fetching data directly from a table is possible.

Any insights or guidance would be greatly appreciated!

Thank You,

Sachitha C

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):