Step to install locally
Task
- Create api for isert/update/delete
- Check how to integrate foreign key - lookup
- Check how to implement trigger - maybe later
- Check out the validation schema and how to use it to integerate required_column, datatype, null value and other column properties
- Create a mapping for select statement - select (*/column_name), from - single table, where
- Create a mapping for insert statement - insert, into, where
- Create a mapping for join - multiple joins, where
- Create mapping for aggregate function -
- Handle group by and having
- Create mapping for sql functions
- Create a mapping for delete statement
- Handle nested queries