Returns a single environment by id. Includes cascade_preview (counts of api_key / alert / deployment / template_snapshot rows that would be deleted on env delete — see FR-090) and in_flight_saga_id (id of the most-recent pending/snapshotting/deploying saga deployment row, or null).