Function sql_insight::extractor::table_extractor::extract_tables

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

Convenience function to extract tables from SQL.

Example

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