As of Rails 7, ActiveRecord supports generated columns for app's backed by a PostgreSQL database. This is achieved with a virtual column.

Try the Hydra Free Tier to create a column-oriented Postgres instance. Then connect to it with your preferred Postgres client (psql, dbeaver, etc). Alternatively, you can run Hydra locally. Benchmarks ...