Use union all - slightly more efficient
diff --git a/api.go b/api.go index dbddea5..216d1bd 100644 --- a/api.go +++ b/api.go
@@ -131,7 +131,7 @@ AND UPPER(a.status) = 'APPROVED' AND c.id = $1 AND c.tenant_id = $2) - UNION + UNION ALL SELECT ap.api_resources, ap.environments,