If anybody is looking for a suiteql editor that has code completion, Anyone can download via bundle with the id 422483 (SuiteQL Monaco Editor). You can also save sql files to the filecabinet to rerun and export. The editor is the monaco editor, which is the same one that powers vscode.

open source?

I haven't made it open source yet but will in the future

great to see some innovation in the SuiteQL space

Nice I’ve been building something similar…

that looks really good! I like the actual files. Which editor are you using? The code completion has really been a life saver when building out new queries for scripts

I originally used Monaco but switched to codemirror as I found it a bit easier to customize as I wanted.

Yeah it's a bit tough. I had to kind of do my own code completion logic but it also allows for easy keyboard shortcuts which I do really like

Nice I will download and give it a try

Well...

@Alan Fitch Do you usually save all of your queries in netsuite apposed to saving them on your local and versioning them in Git? That's my only wonder about being able to save/edit files I really like y'alls concept of being able to open up multiple queries on a single page, so I made an update to be able to open scratch queries and ones saved in the file cabinet but no saving to the files yet.

Versioning them in git would be nice but I usually just save them in NS. Maybe something like this? I noticed you don't have autocomplete on the column names. I can help you out with that if you decide to open source it. I think there's no point of 3 of us working on three separate editors. Mine still has an issue with cors and yours is more polished anyway. cc: @Cory Weiner

@Matt Bernstein this is fantastic. I'd love to contribute as well. A couple of small suggestions meanwhile: keyboard shortcut (e.g. Ctrl + Enter) to execute. Search box in the results. Export to CSV option. Option to rotate the table 90 degrees (can explain more..)

Yes. I will eventually release to be open source and would love to get more help and feedback. There already is a keyboard shortcut(Ctrl/Command + Shift + Enter) to execute and there is also one to format. You can also export as csv if you select the csv format and execute. Intrigued to know the reason for the rotating table 90 degrees

Nice! The use case for rotating the table is I find it makes things so much easier when I'm trying to figure out field names by inspecting sample data. It's a feature I found in SQuirreL SQL. E.g. to figure out what field the "Tax Line" is in SuiteQL, I'd query an existing record and compare the lines. The rotated view makes this a lot easier