/MiniSQL

A mini SQL engine capable of performing very basic functionalities of SQL

Primary LanguagePythonMIT LicenseMIT

MiniSQL

This repository contains a mini SQL engine developed using python, as a part of an assignment in Database Systems in IIIT Hyderabad. The functionalities of the SQL engine are the following: a) Select all records b) Aggregate functions c) Project Columns​ (could be any number of columns) from one or more tables d) Select/project with distinct from one table e) Select with where from one or more tables (with a maximum of one AND/OR clause and no NOT clause) f) Projection of one or more(including all the columns) from two tables with one join condition. For the detailed functionalities of the SQL engine, please refer to the assignment questions.