seesharper/dbexpressions

An abstract syntax tree implementation for SQL

dbexpressions's Issues

Adding a license

This repository currently doesn't have a license, and as per https://choosealicense.com/no-permission/, a repository without a license cannot be used, modified, or shared.

I'd like to use this project, but don't want to encroach on any legal issues. @seesharper , would you consider adding a license for the repository?

Thanks

Delete syntax

Need to add more delete syntax tests as we are moving towards support for Oracle.

It turns out that Oracle can not handle joins as part of the delete statement unless they are wrapped in a sub query.

This means that something like:

delete from orderdetails od inner join orders o on o.Order  = od.orderid and o.order  = -1;

would need to be (re)written to something like:

delete from (SELECT  od.* FROM orderdetails od inner join orders o on o.Orderid  = od.orderid and o.orderid  = -1)

The question is should we rewrite the expression tree or should we handle this in VisitDeleteExpression ?

http://www.dbforums.com/oracle/1006077-delete-join-query.html

Add support for shema/owner specification

Add support for default schema.

dbSelectQuery.SetDefaultSchema("dbo")
.Select(e => e.Column("SomeColumn")).From(e => e.table("SomeTable"));

SQL SERVER

SELECT [SomeColumn] FROM [dbo].[SomeTable] 

Also make it possible to provide the schema using the Table factory method