SELECT util.search_path_append('util');


SELECT mk_derived_col((:table_str, 'dateCollected'),
$$_alt("dateCollected__scrubbed", "dateCollected__verbatim")$$)
; -- runtime: 2 s ("Time: 1734.640 ms") @starscream


SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),
$$_join("specimenDescription", "habitat")$$)
; -- runtime: 1 s ("1113.080 ms") @starscream