Query: kubernetes_cluster_node_pool_details

select
  node ->> 'name' as "Name",
  node -> 'status' ->> 'state' "State",
  node_pool ->> 'name' as "Node Pool Name",
  'do:droplet:' || (node ->> 'droplet_id') as "URN"
from
  digitalocean_kubernetes_cluster as kc,
  jsonb_array_elements(kc.node_pools) as node_pool,
  jsonb_array_elements(node_pool -> 'nodes') as node
where
  kc.urn = $1
order by
  node ->> 'name';