Jira (PDB-5518) Query Engine Improvements

[Austin Blatt (Jira)]

Austin Blatt created an issue

PuppetDB / PDB-5518 Query Engine Improvements Issue Type: Epic Assignee: Unassigned Created: 2022/08/04 1:03 PM Priority: Normal Reporter: Austin Blatt Add Comment

This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)

[Austin Blatt (Jira)]

Austin Blatt updated an issue

PuppetDB / PDB-5518 Query Engine Improvements

Change By: Austin Blatt There are two main benefits to doing the query engine work. 1. The query engine is an entangled and complicated multi-pass compiler, so seemingly easy/small changes in one place can break subsequent passes. This work will move us towards a simpler less entangled query engine, which should be easier for non-experts to work on. 2. The PuppetDB query engine has many places where SQL injection are a concern, this work will allow us to rely on honeysql and jdbc for more robust security guarantees by removing JSONB operator queries that we currently construct by hand.

Add Comment