It used to be an extremely painful experience to only edit a tiny part of the SQL query keeping everything else constant - we hear you! Now, you can just select any part of the SQL on the SQL editor and ask MinusX to edit/modify that specific SQL snippet!
You can always toggle this off in settings -> "Metabase UI Hooks"