This packages provides import from SQL using node-sql-parser
Install:
npm i @react-awesome-query-builder-dev/sql --save
import { Utils } from '@react-awesome-query-builder-dev/core';
import { SqlUtils } from "@react-awesome-query-builder-dev/sql";
const importFromSql = (sqlStr) => {
const {tree, errors: sqlErrors, warnings: sqlWarnings} = SqlUtils.loadFromSql(sqlStr, state.config);
if (sqlErrors.length) {
console.log("Import errors: ", sqlErrors);
}
const {fixedTree} = Utils.sanitizeTree(tree, state.config);
setState({
...state,
tree: fixedTree,
});
};