CLI should log to a file instead of the console

[binaek]

Currently, when we set the log level to TRACE, Steampipe CLI sends its log to the console. While having the log is useful for debugging, it is cumbersome and unwieldy.

Instead, steampipe should always send the log out to a dedicated log file like the plugin-manager and service.

[github-actions]

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

[binaek]

Optionally, we should consider streaming stderr from all components to the CLI stderr

Two env vars to tweak the behavior:

• STEAMPIPE_LOG_TO_STDERR - defaults to false
• STEAMPIPE_LOG_TO_FILE - defaults to true

Postgres has a log_destination config value (link) which can be used to setup multiple log targets depending on which env vars are set.