Function extract_tables

Source
pub fn extract_tables(
    dialect: &dyn Dialect,
    sql: &str,
) -> Result<Vec<Result<Tables, Error>>, Error>
Expand description

Convenience function to extract tables from SQL.

ยงExample

use sql_insight::sqlparser::dialect::GenericDialect;

let dialect = GenericDialect {};
let sql = "SELECT a FROM t1 INNER JOIN t2 ON t1.id = t2.id";
let result = sql_insight::extract_tables(&dialect, sql).unwrap();
println!("{:#?}", result);
assert_eq!(result[0].as_ref().unwrap().to_string(), "t1, t2");