query1.json

# facts endpoint, query API V4, AST
'query=
  ["and",
    ["=", "name", "fact_one"],
    ["in", "certname",
      ["extract", "certname",
        ["and", 
          ["select_facts",
            ["and",
              ["=", "name", "fact_two"],
              ["=", "value", "value_two"]
            ]
          ],
          ["select_facts",
            ["and",
              ["=", "name", "fact_three"]
            ]
          ]
        ]
      ]
    ]
  ]
'

# => No implementation of method: :-plan-> sql of protocol: #'puppetlabs.puppetdb.query-eng.engine/SQLGen found for class nil 

query2.json

# facts endpoint, query API V4, AST
'query=
  ["and",
    ["=", "name", "fact_one"],
    ["in", "certname",
      ["extract", "certname",
        ["and", 
          ["select_facts",
            ["and",
               ["and",
                 ["=", "name", "fact_two"],
                 ["=", "value", "value_two"]
               ],
               ["=", "name", "fact_three"]
             ]
           ]
         ]
       ]
     ]
   ]
'
# => []