Function skipHeadingSQLs

backend/plugin/parser/pg/completion.go:1407–1449

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 skipHeadingSQLs(statement string, caretLine int, caretOffset int) (string, int, int) {
	newCaretLine, newCaretOffset := caretLine, caretOffset
	list, err := SplitSQL(statement)
	if err != nil || len(base.FilterEmptyStatements(list)) <= 1 {
		return statement, caretLine, caretOffset
	}

	start := 0
	for i, sql := range list {
		// Both caretLine and End.Line are 1-based
		// End.Column is 1-based exclusive (points after the last character)
		// caretOffset is 0-based
		sqlEndLine := int(sql.End.GetLine())
		sqlEndColumn := int(sql.End.GetColumn())
		// Use > for End.Column comparison because it's exclusive (points after last char)
		if sqlEndLine > caretLine || (sqlEndLine == caretLine && sqlEndColumn > caretOffset) {
			start = i
			if i == 0 {
				// The caret is in the first SQL statement, so we don't need to skip any SQL statements.
				break
			}
			previousSQLEndLine := int(list[i-1].End.GetLine())
			previousSQLEndColumn := int(list[i-1].End.GetColumn())
			newCaretLine = caretLine - previousSQLEndLine + 1
			if caretLine == previousSQLEndLine {
				// The caret is in the same line as the last line of the previous SQL statement.
				// We need to adjust the caret offset.
				// previousSQLEndColumn is 1-based exclusive, caretOffset is 0-based
				newCaretOffset = caretOffset - previousSQLEndColumn + 1
			}
			break
		}
	}

	var buf strings.Builder
	for i := start; i < len(list); i++ {
		if _, err := buf.WriteString(list[i].Text); err != nil {
			return statement, caretLine, caretOffset
		}
	}

	return buf.String(), newCaretLine, newCaretOffset
}

// caretLine is 1-based and caretOffset is 0-based.
func skipHeadingSQLWithoutSemicolon(statement string, caretLine int, caretOffset int) (string, int, int) {