feat: write support in pg serve

[wesm]

The pg serve read-only PostgreSQL store does not support write operations. Implementing stars, pins, insights, rename, delete, and trash operations against PostgreSQL would allow full functionality when serving from PG.

The db.Store interface already defines the boundaries for these operations — the PG store just needs concrete implementations.

Tracked from the pg-sync refactor spec (out of scope for initial implementation).