feat: implement proxy handler

[abc3]

The current PR introduces a new handler that will replace session mode. It authenticates incoming connections via auth queries, establishes a TCP connection to the tenant's database, and then simply forwards data between the client and the database, functioning primarily as a proxy

• [x] cancel query
• [x] terminate auth_query connection
• [x] active once
• [x] application_name with "via supavisor"
• [x] handle client disconnect
• [x] handle DB disconnect
• [x] auth_query conn is terminated if the client is killed
• [x] telemetry
• [x] delete metrics
• [x] tests

[abc3]

Should we consider using defdelegate in Supavisor.Handlers.Proxy.Handler?

[abc3]

Should we consider using defdelegate in Supavisor.Handlers.Proxy.Handler?

@hauleth wdyt?

[hauleth]

About defdelegate? No strong opinion on that matter.

[abc3]

401