refactor(udf): remove hierarchical usage of schema #21278

Job	Run time
Test shapely and duckdb import	30s
Test ubuntu-latest python-3.9	6m 24s
Test ubuntu-latest python-3.10	4m 51s
Test ubuntu-latest python-3.11	5m 4s
Test ubuntu-latest python-3.12	6m 55s
Doctests	0s
Test windows-latest python-3.9	8m 51s
Test windows-latest python-3.10	10m 19s
Test windows-latest python-3.11	9m 34s
Test windows-latest python-3.12	9m 32s
	1h 2m 0s

Provide feedback