Home

Introduction

patois is an attempt to make a system interface for SQL languages. It has two primary design philosophies:

1. There are enough differences between SQL dialects that it's worth treating them as separate query languages (albeit with some common properties), rather than a single one with a few vendor-specific things.
2. A data-to-SQL library shouldn't be a full database framework, or even necessarily user-friendly. Instead, the intent is to provide low-level interfaces for SQL statements that fully encompass the functionality of their DBMS. Other libraries could be built to provide easier and more generic abstractions. Those libraries could even compile their data structures to patois ones, eliminating the need for anyone to touch SQL strings.

Dialects

Each dialect contains their own set of namespaces. Most of them have significant parts of their structure shared with the others, but their functions and schemas should be viewed completely independent of each other.

• MySQL
• DB2 (coming soon)
• SQLite (coming soon)
• PostgreSQL (coming soon)
• SQL Server (coming soon)