Chore!: Improve the data model and performance of the state sync

[izeigerman]

This update contains the following performance improvements to the state sync:

• Add dev intervals in bulk for new forward-only snapshots. Previously they were added one interval at a time.
• Update the updated_ts property using the UPDATE statement for all impacted snapshots at once when demoting snapshots from an environment.
• Only fetch the plan_id attribute and only update the finalized_ts attribute when finalizing an environment. Previously we serialized / deserialized the full environment object to perform this operation.
• Use the UPDATE statement to update the unpaused_ts attribute for all impacted snapshots at once when unpausing.