Explain about SQL Queries execution that is activated by Data Provider in BO. - BO Designer

Explain about SQL Queries execution that is activated by Data Provider in BO.

- SQL queries are automatically generated at the time of objects are selected
- Upon running, the query is processed pertaining to a database

- Ex: Local Machine Full Client runs query directly
It connects to the appropriate database with the support of a middleware

- The web server will process the query, when the query is run using Webi browser