Can we place multiple SQL queries inside an Oracle DB Adapter?

Summary:

Content (required):

Hi team,

So we are trying to make a REST API integrated with an Oracle OnPrem Database which will be fetching information against a few questions. So we can place a particular SQL query inside the DB Adapter thus making one single REST API. Is there a provision of placing multiple SQL queries inside one single DB Adapter so that we can fetch numerous amounts of information from the database using various parameters of multiple SQL queries?

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

21.4.1

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