ALTER TABLE posts
  ADD COLUMN IF NOT EXISTS is_featured BOOLEAN NOT NULL DEFAULT false;

CREATE INDEX IF NOT EXISTS posts_is_featured_status_published_at_idx
  ON posts (is_featured, status, published_at DESC);