%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left


    %% plan dependencies
    Object9{{"Object[9∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    Access7{{"Access[7∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access8{{"Access[8∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access7 & Access8 --> Object9
    PgSelect6[["PgSelect[6∈0] ➊<br />ᐸpeopleᐳ"]]:::plan
    Object9 --> PgSelect6
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access7
    __Value2 --> Access8
    __Value4["__Value[4∈0] ➊<br />ᐸrootValueᐳ"]:::plan
    __Item10[/"__Item[10∈1]<br />ᐸ6ᐳ"\]:::itemplan
    PgSelect6 ==> __Item10
    PgSelectSingle11{{"PgSelectSingle[11∈1]<br />ᐸpeopleᐳ"}}:::plan
    __Item10 --> PgSelectSingle11
    PgSelect14[["PgSelect[14∈2]<br />ᐸsingle_table_itemsᐳ"]]:::plan
    PgClassExpression13{{"PgClassExpression[13∈2]<br />ᐸ__people__.”person_id”ᐳ"}}:::plan
    Object9 & PgClassExpression13 --> PgSelect14
    PgClassExpression12{{"PgClassExpression[12∈2]<br />ᐸ__people__.”username”ᐳ"}}:::plan
    PgSelectSingle11 --> PgClassExpression12
    PgSelectSingle11 --> PgClassExpression13
    __ListTransform18[["__ListTransform[18∈2]<br />ᐸeach:14ᐳ"]]:::plan
    PgSelect14 --> __ListTransform18
    __Item19[/"__Item[19∈3]<br />ᐸ14ᐳ"\]:::itemplan
    PgSelect14 -.-> __Item19
    PgSelectSingle20{{"PgSelectSingle[20∈3]<br />ᐸsingle_table_itemsᐳ"}}:::plan
    __Item19 --> PgSelectSingle20
    PgSingleTablePolymorphic25["PgSingleTablePolymorphic[25∈4]"]:::plan
    Lambda24{{"Lambda[24∈4]"}}:::plan
    PgSelectSingle22{{"PgSelectSingle[22∈4]<br />ᐸsingle_table_itemsᐳ"}}:::plan
    Lambda24 & PgSelectSingle22 --> PgSingleTablePolymorphic25
    __Item21[/"__Item[21∈4]<br />ᐸ18ᐳ"\]:::itemplan
    __ListTransform18 ==> __Item21
    __Item21 --> PgSelectSingle22
    PgClassExpression23{{"PgClassExpression[23∈4]<br />ᐸ__single_t...s__.”type”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression23
    PgClassExpression23 --> Lambda24
    PgClassExpression26{{"PgClassExpression[26∈4]<br />ᐸ__single_t...parent_id”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression26
    PgClassExpression116{{"PgClassExpression[116∈4]<br />ᐸ__single_t...ems__.”id”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression116
    PgClassExpression118{{"PgClassExpression[118∈4]<br />ᐸ__single_t...__.”type2”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression118
    PgClassExpression119{{"PgClassExpression[119∈4]<br />ᐸ__single_t...author_id”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression119
    PgClassExpression127{{"PgClassExpression[127∈4]<br />ᐸ__single_t...”position”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression127
    PgClassExpression128{{"PgClassExpression[128∈4]<br />ᐸ__single_t...reated_at”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression128
    PgClassExpression129{{"PgClassExpression[129∈4]<br />ᐸ__single_t...pdated_at”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression129
    PgClassExpression130{{"PgClassExpression[130∈4]<br />ᐸ__single_t..._archived”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression130
    PgClassExpression131{{"PgClassExpression[131∈4]<br />ᐸ__single_t...chived_at”ᐳ"}}:::plan
    PgSelectSingle22 --> PgClassExpression131
    PgSelect27[["PgSelect[27∈5]<br />ᐸsingle_table_itemsᐳ<br />ᐳSingleTableTopic<br />ᐳSingleTablePost<br />ᐳSingleTableDivider<br />ᐳSingleTableChecklist<br />ᐳSingleTableChecklistItem"]]:::plan
    Object9 & PgClassExpression26 --> PgSelect27
    PgSingleTablePolymorphic35["PgSingleTablePolymorphic[35∈5]<br />ᐳSingleTableTopic<br />ᐳSingleTablePost<br />ᐳSingleTableDivider<br />ᐳSingleTableChecklist<br />ᐳSingleTableChecklistItem"]:::plan
    Lambda34{{"Lambda[34∈5]"}}:::plan
    PgSelectSingle32{{"PgSelectSingle[32∈5]<br />ᐸsingle_table_itemsᐳ"}}:::plan
    Lambda34 & PgSelectSingle32 --> PgSingleTablePolymorphic35
    PgSelect120[["PgSelect[120∈5]<br />ᐸpeopleᐳ<br />ᐳSingleTableTopic<br />ᐳSingleTablePost<br />ᐳSingleTableDivider<br />ᐳSingleTableChecklist<br />ᐳSingleTableChecklistItem"]]:::plan
    Object9 & PgClassExpression119 --> PgSelect120
    First31{{"First[31∈5]"}}:::plan
    PgSelect27 --> First31
    First31 --> PgSelectSingle32
    PgClassExpression33{{"PgClassExpression[33∈5]<br />ᐸ__single_t...s__.”type”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression33
    PgClassExpression33 --> Lambda34
    PgClassExpression38{{"PgClassExpression[38∈5]<br />ᐸ__single_t...__.”type2”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression38
    PgClassExpression39{{"PgClassExpression[39∈5]<br />ᐸ__single_t...author_id”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression39
    PgClassExpression47{{"PgClassExpression[47∈5]<br />ᐸ__single_t...”position”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression47
    PgClassExpression48{{"PgClassExpression[48∈5]<br />ᐸ__single_t...reated_at”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression48
    PgClassExpression49{{"PgClassExpression[49∈5]<br />ᐸ__single_t...pdated_at”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression49
    PgClassExpression50{{"PgClassExpression[50∈5]<br />ᐸ__single_t..._archived”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression50
    PgClassExpression51{{"PgClassExpression[51∈5]<br />ᐸ__single_t...chived_at”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression51
    First124{{"First[124∈5]"}}:::plan
    PgSelect120 --> First124
    PgSelectSingle125{{"PgSelectSingle[125∈5]<br />ᐸpeopleᐳ"}}:::plan
    First124 --> PgSelectSingle125
    PgSelect40[["PgSelect[40∈6]<br />ᐸpeopleᐳ<br />ᐳSingleTableTopicᐳSingleTableTopic<br />ᐳSingleTableTopicᐳSingleTablePost<br />ᐳSingleTableTopicᐳSingleTableDivider<br />ᐳSingleTableTopicᐳSingleTableChecklist<br />ᐳSingleTableTopicᐳSingleTableChecklistItem<br />ᐳSingleTablePostᐳSingleTableTopic<br />ᐳSingleTablePostᐳSingleTablePost<br />ᐳSingleTablePostᐳSingleTableDivider<br />ᐳSingleTablePostᐳSingleTableChecklist<br />ᐳSingleTablePostᐳSingleTableChecklistItem<br />ᐳSingleTableDividerᐳSingleTableTopic<br />ᐳSingleTableDividerᐳSingleTablePost<br />ᐳSingleTableDividerᐳSingleTableDivider<br />ᐳSingleTableDividerᐳSingleTableChecklist<br />ᐳSingleTableDividerᐳSingleTableChecklistItem<br />ᐳSingleTableChecklistᐳSingleTableTopic<br />ᐳSingleTableChecklistᐳSingleTablePost<br />ᐳSingleTableChecklistᐳSingleTableDivider<br />ᐳSingleTableChecklistᐳSingleTableChecklist<br />ᐳSingleTableChecklistᐳSingleTableChecklistItem<br />ᐳSingleTableChecklistItemᐳSingleTableTopic<br />ᐳSingleTableChecklistItemᐳSingleTablePost<br />ᐳSingleTableChecklistItemᐳSingleTableDivider<br />ᐳSingleTableChecklistItemᐳSingleTableChecklist<br />ᐳSingleTableChecklistItemᐳSingleTableChecklistItem"]]:::plan
    Object9 & PgClassExpression39 --> PgSelect40
    First44{{"First[44∈6]"}}:::plan
    PgSelect40 --> First44
    PgSelectSingle45{{"PgSelectSingle[45∈6]<br />ᐸpeopleᐳ"}}:::plan
    First44 --> PgSelectSingle45
    PgClassExpression46{{"PgClassExpression[46∈7]<br />ᐸ__people__.”username”ᐳ"}}:::plan
    PgSelectSingle45 --> PgClassExpression46
    PgClassExpression126{{"PgClassExpression[126∈8]<br />ᐸ__people__.”username”ᐳ"}}:::plan
    PgSelectSingle125 --> PgClassExpression126

    %% define steps

    subgraph "Buckets for queries/interfaces-single-table/nested-more"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: Access[7], Access[8], Object[9]<br />2: PgSelect[6]"):::bucket
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,__Value4,PgSelect6,Access7,Access8,Object9 bucket0
    Bucket1("Bucket 1 (listItem)<br />Deps: 9<br /><br />ROOT __Item{1}ᐸ6ᐳ[10]"):::bucket
    classDef bucket1 stroke:#00bfff
    class Bucket1,__Item10,PgSelectSingle11 bucket1
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 11, 9<br /><br />ROOT PgSelectSingle{1}ᐸpeopleᐳ[11]<br />1: <br />ᐳ: 12, 13<br />2: PgSelect[14]<br />3: __ListTransform[18]"):::bucket
    classDef bucket2 stroke:#7f007f
    class Bucket2,PgClassExpression12,PgClassExpression13,PgSelect14,__ListTransform18 bucket2
    Bucket3("Bucket 3 (subroutine)<br /><br />ROOT PgSelectSingle{3}ᐸsingle_table_itemsᐳ[20]"):::bucket
    classDef bucket3 stroke:#ffa500
    class Bucket3,__Item19,PgSelectSingle20 bucket3
    Bucket4("Bucket 4 (listItem)<br />Deps: 9<br /><br />ROOT __Item{4}ᐸ18ᐳ[21]<br />1: <br />ᐳ: 22, 23, 24, 26, 116, 118, 119, 127, 128, 129, 130, 131<br />2: PgSingleTablePolymorphic[25]"):::bucket
    classDef bucket4 stroke:#0000ff
    class Bucket4,__Item21,PgSelectSingle22,PgClassExpression23,Lambda24,PgSingleTablePolymorphic25,PgClassExpression26,PgClassExpression116,PgClassExpression118,PgClassExpression119,PgClassExpression127,PgClassExpression128,PgClassExpression129,PgClassExpression130,PgClassExpression131 bucket4
    Bucket5("Bucket 5 (polymorphic)<br />SingleTableTopic,SingleTablePost,SingleTableDivider,SingleTableChecklist,SingleTableChecklistItem<br />Deps: 9, 26, 119, 25, 22, 116, 23, 118, 127, 128, 129, 130, 131<br />ᐳSingleTableTopic<br />ᐳSingleTablePost<br />ᐳSingleTableDivider<br />ᐳSingleTableChecklist<br />ᐳSingleTableChecklistItem<br /><br />1: PgSelect[27], PgSelect[120]<br />ᐳ: 31, 32, 33, 34, 38, 39, 47, 48, 49, 50, 51, 124, 125<br />2: PgSingleTablePolymorphic[35]"):::bucket
    classDef bucket5 stroke:#7fff00
    class Bucket5,PgSelect27,First31,PgSelectSingle32,PgClassExpression33,Lambda34,PgSingleTablePolymorphic35,PgClassExpression38,PgClassExpression39,PgClassExpression47,PgClassExpression48,PgClassExpression49,PgClassExpression50,PgClassExpression51,PgSelect120,First124,PgSelectSingle125 bucket5
    Bucket6("Bucket 6 (polymorphic)<br />SingleTableTopic,SingleTablePost,SingleTableDivider,SingleTableChecklist,SingleTableChecklistItem<br />Deps: 9, 39, 35, 32, 26, 33, 38, 47, 48, 49, 50, 51<br />ᐳSingleTableTopicᐳSingleTableTopic<br />ᐳSingleTableTopicᐳSingleTablePost<br />ᐳSingleTableTopicᐳSingleTableDivider<br />ᐳSingleTableTopicᐳSingleTableChecklist<br />ᐳSingleTableTopicᐳSingleTableChecklistItem<br />ᐳSingleTablePostᐳSingleTableTopic<br />ᐳSingleTablePostᐳSingleTablePost<br />ᐳSingleTablePostᐳSingleTableDivider<br />ᐳSingleTablePostᐳSingleTableChecklist<br />ᐳSingleTablePostᐳSingleTableChecklistItem<br />ᐳSingleTableDividerᐳSingleTableTopic<br />ᐳSingleTableDividerᐳSingleTablePost<br />ᐳSingleTableDividerᐳSingleTableDivider<br />ᐳSingleTableDividerᐳSingleTableChecklist<br />ᐳSingleTableDividerᐳSingleTableChecklistItem<br />ᐳSingleTableChecklistᐳSingleTableTopic<br />ᐳSingleTableChecklistᐳSingleTablePost<br />ᐳSingleTableChecklistᐳSingleTableDivider<br />ᐳSingleTableChecklistᐳSingleTableChecklist<br />ᐳSingleTableChecklistᐳSingleTableChecklistItem<br />ᐳSingleTableChecklistItemᐳSingleTableTopic<br />ᐳSingleTableChecklistItemᐳSingleTablePost<br />ᐳSingleTableChecklistItemᐳSingleTableDivider<br />ᐳSingleTableChecklistItemᐳSingleTableChecklist<br />ᐳSingleTableChecklistItemᐳSingleTableChecklistItem"):::bucket
    classDef bucket6 stroke:#ff1493
    class Bucket6,PgSelect40,First44,PgSelectSingle45 bucket6
    Bucket7("Bucket 7 (nullableBoundary)<br />Deps: 45<br /><br />ROOT PgSelectSingle{6}ᐸpeopleᐳ[45]"):::bucket
    classDef bucket7 stroke:#808000
    class Bucket7,PgClassExpression46 bucket7
    Bucket8("Bucket 8 (nullableBoundary)<br />Deps: 125<br /><br />ROOT PgSelectSingle{5}ᐸpeopleᐳ[125]"):::bucket
    classDef bucket8 stroke:#dda0dd
    class Bucket8,PgClassExpression126 bucket8
    Bucket0 --> Bucket1
    Bucket1 --> Bucket2
    Bucket2 --> Bucket3 & Bucket4
    Bucket4 --> Bucket5
    Bucket5 --> Bucket6 & Bucket8
    Bucket6 --> Bucket7
    end
