join method
JOIN clause
Implementation
QueryBuilder join(
String table, String first, String operator, String second) {
// Simple JOIN implementation - you can extend this for different JOIN types
_selects.add('$table.*'); // Add joined table columns
_wheres.add('$first $operator $second');
return this;
}