toSql method
Implementation
String toSql() {
StringBuffer sb = new StringBuffer();
sb.write(this._sqlInSelect());
//order by
if (_sortList != null) {
sb.write(" ORDER BY ");
sb.writeAll(_sortList!.map((s) => s._toSql()), " , ");
}
//page
if (_pageSize > 0) {
sb.write(
" LIMIT ${_pageSize} OFFSET ${_pageSize * _pageIndex}");
}
//
return sb.toString();
}