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");