[Improvement]: Enable logging based on the appsettings file

### What happened?

At this point only Application Insights
https://github.com/Azure/data-api-builder/blob/a0b64c0196c9f8ec722bafdb0d1e4c9bc8a1a016/src/Service/Program.cs#L131
and Console
https://github.com/Azure/data-api-builder/blob/a0b64c0196c9f8ec722bafdb0d1e4c9bc8a1a016/src/Service/Program.cs#L144
can be configured as the logger output.

As a user I would like to use the appsettings.json configuration to support other ways of preserving the log entries and their log levels.

### Version

0.8.52

### What database are you using?

Azure SQL

### What hosting model are you using?

Local (including CLI)

### Which API approach are you accessing DAB through?

REST

### Relevant log output

_No response_

### Code of Conduct

- [X] I agree to follow this project's Code of Conduct

Start with the logging setup in src/Service/Program.cs at the linked Application Insights and Console configuration points, then inspect how appsettings.json is loaded. Clarify which additional logging outputs and log-level settings are required; done means those agreed options can be configured through appsettings.json instead of only the currently supported outputs.

Written by the indexing model from the issue text.