Consider adding introspection and collision checking to the `Catalog` interface.

[jpschorr]

The current catalog interface, unfortunately, makes it difficult to introspect the functions/aggregates at Session build time.

Originally posted by @jpschorr in #1760 (comment)