Function ExtractOrderBy

ExtractOrderBy(
sql: string,
dialect: SQLParserDialect,
): { orderByClause: string | null; sqlWithoutOrder: string }
Extracts the ORDER BY clause and returns SQL without it. Convenience wrapper around AnalyzeTopLevelOrderBy.
Parameters
- sql: string
- dialect: SQLParserDialect
Returns { orderByClause: string | null; sqlWithoutOrder: string }
Deprecated
Use SqlDocument.Parse(sql, dialect).TopLevelOrderBy(); its Span gives the clause text.
- Defined in packages/SQLParser/dist/orderByAnalyzer.d.ts:52