Text Processingflags: gis

SQL SELECT Statement

Match the column list and table name from a SQL SELECT ... FROM statement.

Available in

JavaScript / ECMAScript code

jsJavaScript

const re = new RegExp("SELECT\\s+(.+?)\\s+FROM\\s+([\\w.\"`\\[\\]]+)", "gis");
const input = "SELECT id, name FROM users";
const matches = [...input.matchAll(re)];
console.log(matches.map(m => m[0]));

Uses `String.prototype.matchAll` for global iteration (Node 12+ / all modern browsers).

Python (re) code

pyPython

import re

pattern = re.compile(r"SELECT\\s+(.+?)\\s+FROM\\s+([\\w.\"`\\[\\]]+)", re.IGNORECASE | re.DOTALL)
input_text = "SELECT id, name FROM users"
for m in pattern.finditer(input_text):
    print(m.group(0))

Stdlib `re` module — no third-party dependency. Works on Python 3.6+.

Go (RE2) code

goGo

package main

import (
	"fmt"
	"regexp"
)

func main() {
	re := regexp.MustCompile("(?is)SELECT\\s+(.+?)\\s+FROM\\s+([\\w.\"`\\[\\]]+)")
	input := `SELECT id, name FROM users`
	for _, match := range re.FindAllString(input, -1) {
		fmt.Println(match)
	}
}

Uses `regexp.MustCompile` (panics on bad patterns at startup) and `FindAllString` for all matches.

Pattern

regexengine-agnostic

SELECT\s+(.+?)\s+FROM\s+([\w."`\[\]]+)   (flags: gis)

Raw source: SELECT\s+(.+?)\s+FROM\s+([\w."`\[\]]+)

How it works

SELECT\s+ matches the keyword and required whitespace. (.+?) lazily captures the column list. \s+FROM\s+ matches the FROM keyword. ([\w."`\[\]]+) captures the table identifier including dots (db.schema.table), and the three quoting styles SQL dialects use: "double", `backtick`, [bracket]. Flags: g (global), i (case-insensitive SELECT/FROM), s (dotAll so columns can span newlines).