Declarative DB

example.sql

--Init:
CREATE TABLE table_name(
  id INT PRIMARY KEY
, name TEXT NOT NULL
)

--Later on:
CREATE TABLE table_name(
  id INT PRIMARY KEY
, name TEXT NOT NULL
, age TEXT NOT NULL
)

--This leads to a migration like:
--up
ALTER TABLE table_name ADD COLUMN age TEXT NOT NULL
--down
ALTER TABLE table_name DROP COLUMN age

-- Couldn't we have something like react which would compare the two table declarations
--  and create the necessary alter table statement if required?

-- For simplicity purposes, this could even be a yaml declaration