fix: move supervisor into metastore #5993

Job	Run time
Build	3m 28s
Lint (clippy)	5m 32s
Format (rustfmt +nightly)	15s
Cache Maintenance	0s
Node.js Binding Tests	4m 45s
PG Protocol Tests	20s
Process Integration Tests (pytest)	1m 6s
Python Binding Tests	6m 55s
SQL Logic Tests (postgres)	13s
SQL Logic Tests (flightsql)	17s
SQL Logic Tests (rpc)	13s
Unit Tests	6m 50s
MinIO Integration Tests (SLT::MinIO)	2m 42s
Service Integration Tests (SLT)	2m 58s
Build and Push Docker Image	0s
Datasource Integration (Clickhouse)	2m 24s
Datasource Integration (SQLite)	2m 42s
Datasource Integration (Cassandra)	1m 57s
Datasource Integration (MySQL)	2m 49s
Datasource Integration (MongoDB)	27s
Datasource Integration (SQLServer)	9m 21s
Datasource Integration (PostgreSQL)	2m 22s
Snowflake Integration Tests (SLT::Snowflake)	2m 12s
	59m 48s

Provide feedback