Optimizing SQL Autoincrement IDs Based on Conditional Requirements

How to Automatically Set 'id' Using MySQL Triggers or UUIDs Instead of AUTO_INCREMENT

How to Create Views in Snowflake with Auto-Increment Columns Using Sequences