readSqlQuery static method

Future<DataFrame> readSqlQuery(
  1. String sql,
  2. String connectionString, {
  3. List? parameters,
})

Reads SQL query results into a DataFrame (pandas-like read_sql_query)

Implementation

static Future<DataFrame> readSqlQuery(String sql, String connectionString,
    {List<dynamic>? parameters}) async {
  final connection = createConnection(connectionString);
  try {
    return await connection.query(sql, parameters: parameters);
  } finally {
    await connection.close();
  }
}