SQL Formatter for Go Developers

// go get github.com/pingcap/tidb/pkg/parser (or use simple string ops)
package main

import (
    "fmt"
    "regexp"
    "strings"
)

// Simple keyword uppercaser
func formatSQL(sql string) string {
    keywords := []string{"select","from","where","join","on","order by","group by","having","limit","insert into","values","update","set","delete from"}
    result := sql
    for _, kw := range keywords {
        re := regexp.MustCompile(`(?i)` + regexp.QuoteMeta(kw) + ``)
        result = re.ReplaceAllString(result, strings.ToUpper(kw))
    }
    return result
}

func main() {
    raw := "select id, name from users where active = 1 order by name"
    fmt.Println(formatSQL(raw))
}