required tables are not in EXTERNAL_REQUIRED_TABLES if the tables are created with recursive DDL

example:

```sql
create or replace table t1 -- ← created
AS (
select *
from t1 -- ← but referenced
union all
select *
from t2
) 
```

For now, we can use `INSERT` or `UPDATE` statements.