feat: tune timeouts and add logging to table trigger setup process

[saikonen]

Add logging for when trigger setup is skipped, and when it fails.

Sets up server-side statement_timeout for DBConfiguration as part of the connection pool for the ui_backend. default is kept as None in case timeouting behavior is not wanted for metadata service.

• [ ] Test that PR introduces no unwanted timeout behavior to metadata service
• [ ] Check that UI Backend correctly handles the new possible errors asyncio.CancelledError and asyncio.TimeoutError

[saikonen]

Still a work in progress due to items on the TODO.