search

unibz-krdb / SemanticSQLTransducer

https://arxiv.org/pdf/2407.07502
GNU Lesser General Public License v2.1
1 stars 0 forks source link

SQL Parsing #1

Open aidan-bailey opened 2 months ago

aidan-bailey commented 2 months ago

SQL Parsing

For the initial milestone, we're just taking in SQL as input (i.e., the source create tables & the target create tables, constraints and mappings). It follows then that we'll have manipulate this information in some way. In order to do this in the sophisticated manner required, we'll have to properly parse them.

JSqlParser looks to be a good candidate to accommodate this.

aidan-bailey commented 2 months ago

Create Tables of the form:

CREATE TABLE ssqlt_test._person(ssn VARCHAR (100) NOT NULL,phone VARCHAR (100) NOT NULL,manager VARCHAR (100),title VARCHAR (100),city VARCHAR (100) NOT NULL,country VARCHAR (100) NOT NULL,mayor VARCHAR (100) NOT NULL,PRIMARY KEY (ssn,phone))

have been successfully parsed