---
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:
  - sqlite
  - db
  - 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-content">
      <div class="embed-card-title">External Link</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.wayl.one/api/file/2b763b3d-1709-47e6-a13d-bfec7baef47d.png)

!!! note

    This post is a <a href="/thoughts/" class="wikilink" data-title="Thoughts" data-description="These are generally my thoughts on a web page or some sort of url, except a rare few don&#39;t have a link. These are dual published off of my..." data-date="2024-04-01">thought</a>. It's a short note that I make
    about someone else's content online <a href="/tags/thoughts/" class="hashtag-tag" data-tag="thoughts" data-count=2 data-reading-time=3 data-reading-time-text="3 minutes">#thoughts</a>