All Projects
cat ~/projects/pgtyped-pydantic/README.md
completed

>PGTyped Pydantic

Completed
Started: February 8, 2024Completed: March 1, 2024

In Python write raw SQL statements, which PGTyped Pydantic will watch for and automatically generate Pydantic models from your database schema - also automatically typing your Python code for you.

>Problem & Solution

Problem

I want to be able to write raw SQL statements in Python, and be able to automatically get correct typed query responses as Pydantic models.

Solution

Forked the PGTyped library - overhauled typescript type generation to Pydantic models. Built a LibCST parser that would watch for special sql invocations and automatically add Pydantic model return types generated by the PGTyped Pydantic library.

>Technologies

SQL
$cd ~/projects
will@diamond:~