getFieldsAs method

List<QSelectField> getFieldsAs(
  1. String from,
  2. String as
)

Gets table fields as select fields with optional table prefixes and aliases.

This method transforms table fields into QSelectField objects suitable for SQL SELECT queries. It handles table prefixes and field aliases.

Parameters:

  • from - The table prefix to use (e.g., 't1', 'users'). If empty, no prefix is added.
  • as - The alias prefix for the selected fields. If empty, original field names are used.

Returns a list of QSelectField objects configured with the specified prefixes and aliases.

Example:

var fields = table.getFieldsAs('users', 'u');
// Generates: users.name AS u.name, users.email AS u.email

Implementation

List<QSelectField> getFieldsAs(String from, String as) {
  return fields.map((field) {
    return QSelectCustom(
        QMath(from.isEmpty ? field.name : "$from.${field.name}"),
        as: as.isEmpty ? field.name : '$as.${field.name}');
  }).toList();
}