1 files changed, 25 insertions, 0 deletions
diff --git a/autoload/ale/fixers/sqlfluff.vim b/autoload/ale/fixers/sqlfluff.vim
new file mode 100644
index 00000000..1dc9f5c1
--- /dev/null
+++ b/autoload/ale/fixers/sqlfluff.vim
@@ -0,0 +1,25 @@
+" Author: Carl Smedstad <carl.smedstad at protonmail dot com>
+" Description: Fixing SQL files with sqlfluff
+
+call ale#Set('sql_sqlfluff_executable', 'sqlfluff')
+
+function! ale#fixers#sqlfluff#Fix(buffer) abort
+    let l:executable = ale#Var(a:buffer, 'sql_sqlfluff_executable')
+
+    let l:cmd =
+    \    ale#Escape(l:executable)
+    \    . ' fix --force'
+
+    let l:config_file = ale#path#FindNearestFile(a:buffer, '.sqlfluff')
+
+    if !empty(l:config_file)
+        let l:cmd .= ' --config ' . ale#Escape(l:config_file)
+    else
+        let l:cmd .= ' --dialect ansi'
+    endif
+
+    return {
+    \   'command': l:cmd . ' %t > /dev/null',
+    \   'read_temporary_file': 1,
+    \}
+endfunction