Power Query does the same with its M language.

Recorded steps in the GUI generate code that can be manually edited.