Once #5123 is merged we can focus on allowing users to opt-in broadly based on pg type kinds. The resulting experience should allow users to start with just base types, including those of plugins they've added and opt into more kinds only as needed.
A user could for instance want to broadly opt into arrays by calling EnableArrays, or ranges by calling EnableRanges. Any of these calls should cause Npgsql to enable all the relevant mappings.
A prototype of the required structure can be found here:
https://gist.github.com/NinoFloris/a4f486b04255c4e09dc484a7c405299c