SqlBuilder class
Fluent SQL query builder for the SDK
Constructors
- SqlBuilder(dynamic _client)
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
build(
) → String - Build the SQL query string
-
execute(
) → Future< SqlQueryResult> - Execute the built query
-
from(
String table, {String? alias}) → SqlBuilder - Set the FROM table
-
groupBy(
List< String> columns) → SqlBuilder - Add GROUP BY columns
-
having(
String condition) → SqlBuilder - Add HAVING clause
-
join(
String table, String condition, {String? alias}) → SqlBuilder - Add an INNER JOIN
-
leftJoin(
String table, String condition, {String? alias}) → SqlBuilder - Add a LEFT JOIN
-
limit(
int value) → SqlBuilder - Set LIMIT
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
offset(
int value) → SqlBuilder - Set OFFSET
-
orderBy(
String column, {bool ascending = true}) → SqlBuilder - Add ORDER BY
-
orderByAsc(
String column) → SqlBuilder - Add ORDER BY ascending
-
orderByDesc(
String column) → SqlBuilder - Add ORDER BY descending
-
orWhere(
String condition) → SqlBuilder - Add OR condition
-
reset(
) → SqlBuilder - Reset the builder for reuse
-
rightJoin(
String table, String condition, {String? alias}) → SqlBuilder - Add a RIGHT JOIN
-
select(
List< String> columns) → SqlBuilder - Add columns to SELECT
-
selectAll(
) → SqlBuilder - Select all columns (*)
-
selectAvg(
String column, [String? alias]) → SqlBuilder -
selectCount(
[String column = '*', String? alias]) → SqlBuilder - Select with aggregate function
-
selectMax(
String column, [String? alias]) → SqlBuilder -
selectMin(
String column, [String? alias]) → SqlBuilder -
selectSum(
String column, [String? alias]) → SqlBuilder -
toString(
) → String -
A string representation of this object.
inherited
-
where(
String condition) → SqlBuilder - Add WHERE condition
-
whereBetween(
String column, dynamic low, dynamic high) → SqlBuilder - Add WHERE column BETWEEN low AND high
-
whereEquals(
String column, dynamic value) → SqlBuilder - Add WHERE column equals value
-
whereGreaterOrEqual(
String column, dynamic value) → SqlBuilder - Add WHERE column >= value
-
whereGreaterThan(
String column, dynamic value) → SqlBuilder - Add WHERE column > value
-
whereIn(
String column, List values) → SqlBuilder - Add WHERE column IN (values)
-
whereLessOrEqual(
String column, dynamic value) → SqlBuilder - Add WHERE column <= value
-
whereLessThan(
String column, dynamic value) → SqlBuilder - Add WHERE column < value
-
whereLike(
String column, String pattern) → SqlBuilder - Add WHERE column LIKE pattern
-
whereNotEquals(
String column, dynamic value) → SqlBuilder - Add WHERE column != value
-
whereNotIn(
String column, List values) → SqlBuilder - Add WHERE column NOT IN (values)
-
whereNotNull(
String column) → SqlBuilder - Add WHERE column IS NOT NULL
-
whereNull(
String column) → SqlBuilder - Add WHERE column IS NULL
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited