Skip to content

Latest commit

 

History

History
80 lines (65 loc) · 1.61 KB

README.md

File metadata and controls

80 lines (65 loc) · 1.61 KB

JSON to SQL Query for MS SQL Server

This library is ported from JSON to SQL Query at https://github.com/xbsoftware/querysql to C# & .NET Core to convert JSON config to SQL Query with named parameters for Microsoft SQL Server.

The Microsoft .NET Framework Data Provider for SQL Server does not support the question mark (?) placeholder for passing parameters to a SQL Statement. Named parameters must be used. See details here

The following is copied from xbsofware/querysql/README.md

Converts JSON config to SQL Query

{
  "glue": "and",
  "rules": [{
    "field":"age",
    "condition":{
      "type": "less",
      "filter": 42
    } 
  },{
    "field":"region",
    "includes": [1,2,6]
  }] 
}

Supported operations ( type )

  • equal
  • notEqual
  • contains
  • notContains
  • lessOrEqual
  • greaterOrEqual
  • less
  • notBetween
  • between
  • greater
  • beginsWith
  • notBeginsWith
  • endsWith
  • notEndsWith

nesting

Blocks can be nested like next

{
  "glue": "and",
  "rules": [
    ruleA,
    {
      "glue": "or",
      "rules": [
        ruleC,
        ruleD
      ] 
    }
  ] 
}

between / notBeetween

For those operations, both start and end values can be provided

{
    "field":"age",
    "condition":{
      "type": "between",
      "filter": { "start": 10, "end": 99 }
    } 
  }

if only start or end provided, the operation will change to less or greater automatically