Function skipHeadingSQLWithoutSemicolon

backend/plugin/parser/pg/completion.go:1452–1490

caretLine is 1-based and caretOffset is 0-based.

(statement string, caretLine int, caretOffset int)

// caretLine is 1-based and caretOffset is 0-based.
func skipHeadingSQLWithoutSemicolon(statement string, caretLine int, caretOffset int) (string, int, int) {
	tokens := pgparser.Tokenize(statement)
	caretByteOff := lineColumnToByteOffset(statement, caretLine, caretOffset)

	latestSelectOffset := -1
	latestSelectLine := 0
	newCaretLine, newCaretOffset := caretLine, caretOffset

	for _, tok := range tokens {
		if tok.Loc >= caretByteOff {
			break
		}
		if tok.Type == pgparser.SELECT {
			// Check that this SELECT starts at column 0 of its line.
			// Either it's the first byte of the string, or the byte immediately
			// before it is a newline.
			atColumn0 := tok.Loc == 0 || statement[tok.Loc-1] == '\n'
			if atColumn0 {
				latestSelectOffset = tok.Loc
				// Compute the line number of this token.
				line := 1
				for j := 0; j < tok.Loc; j++ {
					if statement[j] == '\n' {
						line++
					}
				}
				latestSelectLine = line
				newCaretLine = caretLine - latestSelectLine + 1
				newCaretOffset = caretOffset
			}
		}
	}

	if latestSelectOffset < 0 {
		return statement, caretLine, caretOffset
	}

	return statement[latestSelectOffset:], newCaretLine, newCaretOffset
}

func (c *Completer) listAllSchemas() []string {
	if _, exists := c.metadataCache[c.defaultDatabase]; !exists {