Replacing every occurrence of table with sqlparser-rs

[kasvith]

Hi,

I want to do something like this with sqlparser-rs

I've a query like

SELECT foo.id from foo;

I need to change foo to foo_1 where its referenced as a table

SELECT foo_1.id FROM foo_1;

I tried visitor_relation_mut, but its does not replace occurrences in the SELECT

[alamb]

the foo.id in the SELECT list will be an Expr -- so you would have to use one of the expr visiting methods like post_visit_expr for this: https://docs.rs/sqlparser/0.36.1/sqlparser/ast/trait.VisitorMut.html#method.post_visit_expr