Function normalizeDefaultExpressions

database/mssql/parser.go:58–110

SQL Server exports DEFAULT constraints as nested parenthesized expressions like DEFAULT ((0)) or DEFAULT (newid()). The generic parser only needs the underlying expression, so collapse the redundant outer parentheses here.

(sql string)

// like DEFAULT ((0)) or DEFAULT (newid()). The generic parser only needs the
// underlying expression, so collapse the redundant outer parentheses here.
func normalizeDefaultExpressions(sql string) string {
	var b strings.Builder

	for i := 0; i < len(sql); {
		switch {
		case hasLineCommentPrefix(sql, i):
			next := scanLineComment(sql, i)
			b.WriteString(sql[i:next])
			i = next
		case hasBlockCommentPrefix(sql, i):
			next := scanBlockComment(sql, i)
			b.WriteString(sql[i:next])
			i = next
		case sql[i] == '\'':
			next := scanSingleQuotedString(sql, i)
			b.WriteString(sql[i:next])
			i = next
		case sql[i] == '"':
			next := scanDoubleQuotedString(sql, i)
			b.WriteString(sql[i:next])
			i = next
		case sql[i] == '[':
			next := scanBracketIdentifier(sql, i)
			b.WriteString(sql[i:next])
			i = next
		case hasKeywordAt(sql, i, "DEFAULT"):
			end := i + len("DEFAULT")
			b.WriteString(sql[i:end])

			j := end
			for j < len(sql) && isSpace(sql[j]) {
				b.WriteByte(sql[j])
				j++
			}

			if j < len(sql) && sql[j] == '(' {
				expr, next, ok := scanBalancedParenthesizedSQL(sql, j)
				if ok {
					b.WriteString(stripOuterSQLParens(expr))
					i = next
					continue
				}
			}

			i = j
		default:
			b.WriteByte(sql[i])
			i++
		}
	}

	return b.String()
}

func normalizeQualifiedReservedIdentifiers(sql string) string {
	var b strings.Builder