Caret Plugin::SQL and DAX Formatter

This Caret plugin formats SQL and DAX for pretty print

The options for sql-formatter are passed via "options"

Please open tickets on GitHub
https://github.com/DanShrader/Caret-Plugin-Pretty-SQL

Change Log:
Fixed the ' = ' issue

To use with Caret

You'll need to add the following to your api.json file, under settings menu. This plugin can pass the same options that sql-formatter does in the 'options' tag. Note: The id is the id found under extensions. The one in here is for the plugin on the webstore.

api.json

{
"sampleMessage": {
"id": "extension id goes here",
"message": {
"data": "message can be any JSON object passable to chrome.runtime.sendMessageExternal"
}
},
"format-SQL": {
"id": "fnkfgnggimkijjldpalcfjfomhipodib",
"message": {
"command": "sql-format",
"options": {
"indent": "\t"
}
},
"sendEditorContext": true
},
"format-DAX": {
"id": "fnkfgnggimkijjldpalcfjfomhipodib",
"message": {
"command": "dax-format",
"options": {
"indent": "\t"
}
},
"sendEditorContext": true
}
}

menus.json

This is optional, but allows the command to be accessable in menu system.

{
"label": "Format SQL",
"command": "api:execute",
"argument": "format-SQL"
}, {
"label": "Format DAX",
"command": "api:execute",
"argument": "format-DAX"
}

The following have contributed works

Without the following, this plug-in would not exist. Thanks to their works.

Caret
https://github.com/thomaswilburn/Caret

sql-formatter
https://github.com/zeroturnaround/sql-formatter

Microsoft for SSAS and DAX