thorsten-de/query-builder

A humble but eloquent builder for sql query strings in C#/.NET

query-builder's Issues

Implement FROM and JOIN clauses

FROM and JOIN clauses are implemented with the following features:

Required:

• tables
• table alias
• join types (INNER, LEFT, RIGHT, FULL, CROSS)
• join conditions

Nice to have

• Subqueries and derived tables

Improve condition operators

Right now, there are only equality operators supported. In this issue, these topics are addressed:

• Combine sequences of AND/OR Conditions without parenthesis: This is harder than initially thought
• Complete comparison operators: expression {>, >=, <, <=} expression
• string_expression LIKE string_expression
• expression BETWEEN expression AND expression
• expression IS NULL
• expression IN ( expression+)

Note that IN doesn't support subquerys so far, as EXISTS is further down the roadmap.

Add basic conditions and expressions

Basic conditions and expressions are defined with their corresponding operators

Define solution and projects

In the first step, the .NET solution and following projects are defined:

• QueryBuilder: Core project to define a public api for query builders. In the first iterations, this will be a console application in order to evaluate the syntax easily.
• QueryBuilderTests: Unit tests for QueryBuilder using the XUnit test framework.

Specify columns in select list

Columns should be specified for select. Some features that are considered:

Required:

• * and table.* columns
• colums that map to table attributes
• aliasing columns

Nice to have:

• defining columns using expressions
• using functions to extend expressions