[scd] Stop using pgx.ErrNoRows to indicate no results

[the-glu]

Use a custom error instead.

Initially reported during raft migration here: https://github.com/interuss/dss/pull/1542/changes#r3426524948