Application Design Guidance :
Has to be REST Based Service.
Retrieving data from Oracle Database.
Columns in select can change and are configurable after the deployment (Thinking of query store where we can store oracle selects and retrieving them before firing off to back end. Advise needed if there are any design patterns that can solve this)
Whole select statements and where clause should be configurable (in XML file or Database) there will be parameters that will replace in where.
Data is shown in the grid by the consumer (sharepoint web part, webform, windows forms etc., depends on the use)
Advise on the design pattern that i can use.
Important is the REST based service , is it good (performance wise) to return a data table form rest based service. I do not want to use strongly typed data sets because whole selects are configurable.