Add PGlite support

Project Overview

The goal of this project is to extend the capabilities of the existing compiler framework to support testing PGLite skills of end users using electric-sql/pglite. The addition will allow for PGLite-like PGLite queries to be tested, ensuring that users can perform and validate their PGLite operations effectively. This will involve setting up a pg-lite database, executing user-provided PGLite queries, and comparing the results against expected outputs.

Key Features

1. Database Setup and Configuration: Establish a pglite database environment where the PGLite queries will be executed.

2. PGLite Query Execution: Implement functionality to execute PGLite queries provided by the user on the pg-lite database.

3. Result Comparison: Compare the results of the user's PGLite query with the expected results to determine correctness.

4. Error Handling and Logging: Ensure robust error handling and logging mechanisms to provide meaningful feedback to users.

5. Integration with Existing System: Seamlessly integrate the pg-lite support with the existing system, making use of similar patterns used for SQLite.