Skip to content
View jliu4950's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report jliu4950

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
jliu4950/README.md

June Liu

Hi, I'm June Liu

M.S. Computer Science at Northeastern University, building reliable AI applications and scalable backend systems. Seeking a Summer 2027 software engineering / AI internship.

Five years of production experience before the degree: an LLM Text-to-SQL agent and a CRM platform at an industrial-supply company, and lead-routing and streaming-analytics services at a real-estate brokerage.

Python Java FastAPI Spring%20Boot PostgreSQL Kafka AWS LLM%20Applications

Selected Projects

Project What it does Stack
QueryGuard CI Text-to-SQL service that treats model output as untrusted: schema retrieval, sqlglot AST validation, and row-level authorization injected server-side. 25-case eval suite runs in CI on Python 3.9–3.13. FastAPI · sqlglot · SQLAlchemy · SQLite

QueryGuard — the part worth looking at

A sales rep asks for "my customer orders". They never say which customers are theirs, and the model is never asked to scope the query. The customer_assignments predicate in the generated SQL is injected by the server after validation — authorization is a query transformation, not a prompt instruction.

QueryGuard dashboard showing a sales-rep query whose generated SQL contains the server-injected authorization predicate

On the repository's deterministic fictional dataset the 25-case suite reports execution accuracy 1.0, zero authorization violations, and a 1.0 safety interception rate. Those numbers describe this demo harness, not general Text-to-SQL model quality — the README is explicit about the scope and the limitations.

Currently

Updated September 2026

  • Extending QueryGuard's evaluation suite with an adversarial subset covering prompt-injection attempts against the authorization layer.
  • Building an event-driven backend service with load-test and observability evidence.
  • Daily algorithm practice in neetcode-submissions.

What I Work On

  • AI systems: LLM applications, retrieval, evaluation, and safety guardrails
  • Backend systems: APIs, data modeling, event-driven services, caching, and observability

Connect

LinkedIn · jliu4950@gmail.com

Pinned Loading

  1. queryguard queryguard Public

    Safe, evaluation-driven Text-to-SQL demo with server-enforced authorization.

    Python