Looks like through_tables doesn't work in nested node

[ashrowty]

if i try to bring in a child table using a through_table at the second level, it doesn't work

structure -

root
child1
child2 through_table child1_child2

however i tried the exact same tables at first level and this works -
child1
child2 through_table child1_child2

when i look at the stack trace, it doesn't seem to want to go through the _through() path. instead it goes through _non_through() path -

pgsync/pgsync/querybuilder.py

Line 739 in e4acd7d

self._non_through(node)

should i file a bug?

[toluaina]

Yes please open an issue with as much details as you can

[goktugbati]

I had the same issue and solved it by creating a materialized view. only difference compared to tables is that you provide primary key and base tables in the schema.json as below

"nodes": {
  "table": "elastic_form_view",
  "primary_key": [
    "id"
  ],
  "base_tables": [
    "node",
    "space"
  ],