I would like to annotate column types for my current use cases. But I think being able to restrict valid column values to a pick list backed by ontology terms would be very useful too.

Instead of importing static version of certain vocabularies and maintaining mappings is it possible to integrate with something like NCBO's BioPortal? They provide a REST API to many of the common vocabulaties/ontologies.