Configure search_path

[prog8]

What do you want to change?

Today catalog.Catalog has a field called SearchPath. The only place it is configured is hardcoded and is part of catalog initialization here.

It's a common use case to have search_path per connection and then one expects not to use full name like schema.table but just call table explicitly. It'd be good to have ability to configure search_path when sqlc generate is triggered.

What database engines need to be changed?

No response

What programming language backends need to be changed?

No response