Get the position of an AST item in the input

[Wisser]

Is it possible to determine the position (start and end index in the SQL string to be parsed) of an item in the AST?
E.g.: I parse "Select a, b from t" and get (7, 11) as position for the "SelectItemsList".

[manticore-projects]

Yes. Look at the AST Test case. It shows you how to access the nodes. Best regards Andreas

…

On Sun, 2021-05-30 at 01:44 -0700, Wisser wrote: Is it possible to determine the position (start and end index in the SQL string to be parsed) of an item in the AST? E.g.: I parse "Select a, b from t" and get (7, 11) as position for the "SelectItemsList". — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[Wisser]

That's great!
Thanks for the quick reply.

[Wisser]

Unfortunately, this does not work for all items.
Or am I missing something?

For example, I encountered the following problems:

FromItem (PlainSelect#getFromItem) is not an ASTNodeAccess.
Expression (PlainSelect#getWhere) is null for complex expressions.