---
title: "Meet Gor on X: \"SQLite added generated columns in 3.31 (around..."
description: "!https://x.com/MeetGor21/status/1967818642768470447"
date: 2025-09-16
published: true
tags:
  - database
  - db
  - sqlite
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://x.com/MeetGor21/status/1967818642768470447" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-image">
      <img src="https://pbs.twimg.com/profile_images/1525159269716271104/qDL6ffwc_200x200.jpg" alt="Meet Gor (@MeetGor21) on X — SQLite added generated columns in 3.31 (around Jan 2020)

Postgres added generated columns with virtual and as default in v18 (to be released September 2025)

There is still a lot to learn in SQL and adoption is still going on, even in the most used databases" loading="lazy">
    </div>
    <div class="embed-card-content">
      <div class="embed-card-title">Meet Gor (@MeetGor21) on X</div>
      <div class="embed-card-description">SQLite added generated columns in 3.31 (around Jan 2020)

Postgres added generated columns with virtual and as default in v18 (to be released September 2025)

There is still a lot to learn in SQL a...</div>
      <div class="embed-card-meta">X (formerly Twitter) &middot; x.com</div>
    </div>
  </a>
</div>


I've never tried generated columns, but it is something that I'm interested in.  It is nice to have things computed and in the database if you ever need to query on them.  My brain is now churning with possibilities and quesions, does this work with Alembic? How does this compare to views?

![screenshot-2025-09-16T13-52-48-868Z.png](https://dropper.waylonwalker.com/api/file/2b763b3d-1709-47e6-a13d-bfec7baef47d.png)