[FEATURE] BI tools compliance with complex objects

[kushagraag2003]

Is your feature request related to a problem?
Opensearch and SQL plugin use dot notation to delimit fields and subfields for nested objects. BI tools (like Power BI and Tableau,etc ) don't use DESCRIBE request to get list of columns. Instead it uses queries like select * to get list of columns
Follow up of #1793

What solution would you like?
Add new SQL plugin setting with boolean value. By default it is deactivated (unset). Once set, it will enforce expanding all complex objects in select * query.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.