[data-export]: Update data-export textarea to modern code editor

[sqone2]

Hey Thomas! What do you think about upgrading the textarea in data-export with a more IDE-like modern code editor?

Benefits:

• Copy and pasting queries from your IDE will carry over indention
• Autocomplete/Intellisense will be more intuitive to users who are new to SFI but are familiar with using an IDE
• Themes: light/dark mode out of the box
• Comforts like indention, parenthesis matching, keyboard shortcuts, etc

This is not something I have prior experience with, but after doing some research here are some options:

• Ace
• Codemirror
• Monaco

After doing some experimenting, Ace seems like a great option. It has all the features you would want and has great documentation/community.

I'm going to submit a MVP PR shortly for you to review and let me know what you think about the idea!

[tprouvot]

Hi @sqone2,

This is something that can be useful for users, however I don't want to load a massive library just to edit SOQL queries.
ie killing a fly with a bazooka 😄

If the lib is very light I'll consider this addition

[sqone2]

Thanks for the feedback @tprouvot!

I agree that adding a library is a lot of added lines, but I disagree about the size of the "fly". I use SFI every day, and the majority of that time is spent writing and editing queries in data-export. I'd say my usage of the extension is 80% data-export, and I wonder if other users would say something similar. Given that data-export is such a cornerstone of the app (for me anyway), I think upgrading the query editor would have a huge net benefit.

Another thing that I think SFI can make a huge impact on is writing/editing Salesforce formulas. IMO they are a huge pain in the neck. My typical workflow for complex formulas is write them in VS code, and then copy and paste them over to SF. How amazing would it be if SFI could assist users with autocomplete, parentheses highlighting, and maybe even real time error highlighting? 🤤 Having a code editor library in the mix could allow us to bring those features to life.

To illustrate some of this, I hope you don't mind if I share some screenshots that I HOPE will help swing you over to my line of thinking 😄

Field autocomplete (twilght theme)

Object autocomplete (twilight theme)

Parentheses highlighting (default theme)

Auto expanding editor (cobalt theme) (right now its set to 30, but we could allow the user to control this setting)