Readonly isPrivate Optional Readonly rawPrivate Optional Readonly rawReadonly sqlReadonly valuesStatic Readonly ascStatic Optional customStatic Readonly descStatic Readonly emptyStatic isStatic avgStatic countStatic createAllow create an instance of SQLSyntax from a string variable sqlStr.
The content of the string variable sqlStr will become the SQL query string without any escaping.
You might need this method to create indentifier (e.g. tbale or column names) as SQLSyntax.
Make sure you process the string input well to avoid SQL injection vulnerability.
SQLSyntax
Static csvStatic defaultStatic distinctStatic eqStatic existsStatic filterStatic geStatic groupStatic gtStatic hasStatic havingStatic inStatic isStatic isStatic joinStatic joinStatic joinStatic leStatic likeStatic limitStatic ltStatic maxStatic minStatic notStatic notStatic notStatic offsetStatic orderStatic roundStatic sqlsStatic sumStatic whereGenerated using TypeDoc
An class represents a SQL query piece / fragment. The provided
sqlstagged template literals will output an instance of SQLSyntax class. All properties of SQLSyntax are readonly. Thus is immutable. An instance of SQLSyntax class will record