lead method

@override QueryBuilder lead(String column, { int offset = 1, dynamic defaultValue, String? partitionBy, String? orderBy, String? as, })

Implementation

@override
QueryBuilder lead(
  String column, {
  int offset = 1,
  dynamic defaultValue,
  String? partitionBy,
  String? orderBy,
  String? as,
}) {
  if (column.isEmpty) {
    throw InvalidArgumentException(
        'Column name cannot be empty for LEAD function');
  }

  String leadFunc = "LEAD($column, $offset";
  if (defaultValue != null) {
    if (defaultValue is String) {
      leadFunc += ", '$defaultValue'";
    } else {
      leadFunc += ", $defaultValue";
    }
  }
  leadFunc += ")";

  final overClause =
      _buildOverClause(partitionBy: partitionBy, orderBy: orderBy);
  _addWindowFunction(leadFunc, overClause, as);
  return this;
}