From PR: https://github.com/ManageIQ/manageiq/pull/8870 virtual columns can have corresponding sql, use these columns in the database. This is a big performance boost.