sql method

Future<SqlQueryResult> sql(String query)

Executes a SQL-like query (BaaSQL)

Example:

final result = await db.sql('''
  SELECT name, email, COUNT(*) as order_count
  FROM users
  LEFT JOIN orders ON users.id = orders.user_id
  WHERE created_at > '2024-01-01'
  GROUP BY users.id
  ORDER BY order_count DESC
  LIMIT 10
''');

Implementation

Future<SqlQueryResult> sql(String query) async {
  final response = await _client.post(
    Uri.parse('$baseUrl/sql'),
    headers: _headers,
    body: jsonEncode({'sql': query}),
  );

  final data = _handleResponse(response);
  return SqlQueryResult.fromJson(data);
}