On this page:
Plisqin
7.1

Plisqin

First time here? Go read the Introduction instead.

Code is available on GitHub.

    1 Introduction

      1.1 Appendable Queries

      1.2 Reusable Joins

      1.3 Inline Joins

      1.4 Aggregates

      1.5 Putting it All Together

    2 Getting Started

      2.1 Project Status

      2.2 The Example Database Schema

      2.3 Strings vs Procedures

      2.4 Environment Setup

    3 Walkthrough

      3.1 Layer 0 - The Core

        3.1.1 Fragments

        3.1.2 From

          3.1.2.1 Appending Queries

          3.1.2.2 Always Use the Alias!

          3.1.2.3 Query Contents

        3.1.3 Join

          3.1.3.1 Attached vs Detached Joins

          3.1.3.2 Joined Subqueries

          3.1.3.3 Join-to-Query Conversion

        3.1.4 Injections

          3.1.4.1 Aggregate Injection in Depth

          3.1.4.2 Nested Aggregates

      3.2 Layer 1 - Schema as Procedures

        3.2.1 Tables

        3.2.2 Columns

        3.2.3 Joins

          3.2.3.1 Singular Join Examples

          3.2.3.2 Plural Join Examples

          3.2.3.3 Grouped Join Examples

        3.2.4 Derived Scalars

      3.3 Layer 2 - SQL as Procedures

    4 Reference

      4.1 Fragments

      4.2 SQL Functions

      4.3 Data Model

      4.4 Terminology

    5 Video Rental Example Schema

      5.1 Tables

      5.2 Singular Relationships

      5.3 Plural Relationships

      5.4 Grouped Relationships

      5.5 Fields

    6 For Developers

      6.1 What Next?

      6.2 Design Notes

        6.2.1 Why do sources need UIDs?

        6.2.2 Dotted Identifiers

        6.2.3 Name Clashes and Infix Notation

      6.3 Tests