some normalization functions for use in in-DB ingest, when it happens