Add Postgres Query Field to Custom Assets

For example, Say I have ConnectWise Config Type "Domain Names" synced over. I would like to add a field in the "Domain Name" hudu asset to parse the field whois__details.raw and present certain strings like Registrar, name servers, etc. This eliminates the need to enter the fields in ConnectWise manually (it's ok that the data isn't in CW, we mainly use it to kickoff domain expiration workflows, the config questions don't get used).
If there's a better way to do this I'm all ears.
Thanks
Brian