[FEATURE] Ability to nest tables/views/etc under their parent schema or database config

[GClunies]

I'd like the ability to nest tables/views/etc under their parent database and/or schema config. Something like this.

# test_db.yml

databases:
  - name: test_db
    schemas:
      - name: test_schema
        tables:
          - name: test_table
            columns:
              - name: col1
                data_type: string
              - name: col2
                data_type: integer
                
          - name: test_table_2
             columns:
              - name: col1
                data_type: boolean
              - name: col2
                data_type: number
                 
        views:
          - name: test_view
            columns:
              - name: col1
                data_type: string
              - name: col2
                data_type: integer

I am not sure how far you want to extend this idea. Maybe the same would be possible for anything that is defined at the schema level (tables, views, file formats, stages, tasks, streams, sequences, procedures, etc)?

I am not certain I would always use the nesting for everything, but the flexibility would be nice.