feat(sql): optimize search queries with JOIN-based label filtering and trigram indexes #17680

Job	Run time
Lint and Validate	7s
Build / Build Java Application (no tests)	5m 26s
Build / Build UI Application	3m 9s
Unit Tests / Unit Tests	11m 1s
Native Build / Build Native Image	4m 26s
SDK Verification / Verify Go SDK	1m 26s
Extra Tests / Build and Run Application examples	6m 0s
Extra Tests / Integration Tests Legacy V2	3m 49s
SDK Verification / Verify Python SDK	3m 28s
Extra Tests / Integration Tests Typescript SDK	35s
Extra Tests / Extra Tests	8m 19s
Extra Tests / Integration Tests UI	15m 35s
Integration Tests / Integration Tests (h2-migration)	11m 10s
Integration Tests / Integration Tests (h2-ci)	10m 28s
Integration Tests / Integration Tests (postgresql-migration)	10m 47s
Integration Tests / Integration Tests (postgresql-ci)	10m 15s
Integration Tests / Integration Tests (kafkasql-kafkasql-snapshotting)	10m 52s
Integration Tests / Integration Tests (postgresql-auth)	11m 6s
Integration Tests / Integration Tests (h2-auth)	11m 1s
Integration Tests / Integration Tests (kafkasql-auth)	10m 51s
Integration Tests / Integration Tests (kafkasql-migration)	11m 25s
Integration Tests / Integration Tests (kafkasql-ci)	10m 30s
Integration Tests / Integration Tests (h2-debezium-all)	10m 21s
Native Build / Test Native (${{ matrix.profile }})	-1s
Trigger 3scale Deploy	0s
Publish Images	0s
Slack Notification	0s
	3h 2m 6s

Provide feedback