/pg_go_parse

Primary LanguageGo

WIP

This repo is a WIP

Introduction

A native go library can parse a postgres sql statement and return the postgres syntax tree of that sql statement

Motivation

The current tools, go-pgquery and pg_query_go rely on wasm and underlying c files to build the syntax tree. That might work for some folks but it's also a heavy handed approach that might take up too much memory.

So we want to write a native go library that can parse a sql statement represented as a string and return the postgres syntax tree without having to worry about building a wasm module with c files.

todo

  • make all statements case insensitive in parser
  • update targetlist in select stmt to be more flexible
  • need to be abel to handle fully qualified identifeirs and tables, right now it's all relative i.e. users works fine, but table.users doesn't