Groups Category
Operators Category
Identifiers Category
Clauses Category
Constants Category
Comments Category
Variables Category
Keywords Category
Punctuation Category
Unknown Category
Predefined Category
System Category

SQL Enlight uses a XML-based language to describe T-SQL statements called SQML which stands for Structured Query Markup Language.

T-SQL batch as SQML:

<g:batch>
<g:statements>
  <pu:semicolon>
    <g:statement>
	...
    </g:statement>
  </pu:semicolon>
</g:statemetns>
</g:batch>

SQML elements are separated in different categories which  have specific namespaces.

<g:batch>
<g:statements>
  ...
    <g:statement>
	...
    </g:statement>
  ...
</g:statemetns>
</g:batch>

Namespace for all container elements.The namespace prefix is "g:".

Operators

All arithmetic and bitwise operatros are scoped in this namespace. The namespace prefix is "o:". SQML uses prefix notation (Polish notation) to descried arithmetic and logical expressions. The operator is the parent element and operands are written as child elements. The first child represents the left operand and the second child represents the right operand in the expression.

The elements form this group have these attributes:

T-SQL arithmetic expression:

a + b + 1

SQML:

<g:expression>
     <o:additive name="+">
             <o:additive name="+">
                <i:common name="a"/>
                <i:common name="b"/>
             </o:additive>
           <co:exact-number>1</co:exact-number>
     </o:additive>
</g:expression>

T-SQL logical expression:

a>1 and b = 3

SQML:

<g:boolean-expression>
<k:and>
	<o:comparison name=">">
		<g:expression>
			<i:common name="a"/>
		</g:expression>
		<g:expression>
			<co:exact-number>1</co:exact-number>
		</g:expression>
	</o:comparison>
	<o:comparison name="=">
		<g:expression>
			<i:common name="b"/>
		</g:expression>
		<g:expression>
			<co:exact-number>3</co:exact-number>
		</g:expression>
	</o:comparison>
</k:and>
</g:boolean-expression>

Identifiers

There are four kinds of identifiers delimited, quoted, labels common. The Namespace prefix is "i:".

Multipart identifiers are represented using prefix notation as the parent element is the pu:binding[@name="."].The child elements are the left and the right identifier elements.

The elements form this group have these attributes:

T-SQL multipart identifier:

server_name.[database_name].[schema_name].object_name

SQML:

<pu:dot>
	<i:common name="server_name"/>
		<u:dot>
			<i:delimited name="database_name"/>
			<u:dot>
				<i:delimited name="schema_name"/>
			<i:common name="object_name"/>
		</u:dot>
	</u:dot>
</u:dot>

Clauses

All T-SQL clauses are in this category. The namespace prefix is "c:". The names of the elements which belong to this category are the names of actual T-SQL clauses. The names are in lowercase.

Constants

All constant values are in this category. The values of elements from this namespace are written in as element content. The namespace prefix for is "co:".

TSQL:

3

'literal string'

SQML:

<co:exact-number>3</co:exact-number>

<co:string>'literal string'</co:string>

Comments

The comments in the T-SQL script are in this category. The comments are stored in as content of the element. The namespace prefix for this category is "cmt:".

Comment elements are attached to the last token before the comment itself.

T-SQL:

SELECT column1, column2  FROM table1 /* test comment */

SQML:

<k:select>
	<g:commalist>
	...
	</g:commalist>
	<k:from>
	<g:commalist>
		<i:common name="table1">
			<cmt:multiline>/* test comment */</cmt:multiline>
		</i:common>
	</g:commalist>
	</k:from>
</k:select>

Variables

This is a category for the T-SQL variables. Variable name is written in the name attribute. The namespace prefix for this category is 'v:'.

The elements form this group have these attributes:

Keywords

All T-SQL reserved keywords are in this category. The namespace prefix is "k:". The names of the elements which belong to this category are the names of actual T-SQL reserved keywords. The names are in lowercase.

Punctuation

The namespace prefix for this category is "pu:".

The elements form this group have these attributes:

Example SQML:

<g:batch>
<g:statements>
	<pu:semicolon>
		<g:statement>
		 ...
		</g:statement>
	</pu:semicolon>
</g:statements>
</g:batch>

Unknown

This category holds the T-SQL syntax elements which not fall in any of the other categories. We are working on removing such elements, but there are a few left. The namespace prefix for this category is "u:". The only element which belongs here is the 'unknown' element.

The elements form this group have these attributes:

Predefined

This category includes well known T-SQL object names (such as data types, set options, hints and etc.) which have specific scope and usage in the T-SQL grammar. The namespace prefix for this category is "pr:".

The elements form this group have these attributes:

System

SQL Enlight adds some specific attributes which to be later used by the analysis engine. The attributes specify the position of the tokens and optionally their type.

The namespace prefix is "se:".

Example SQML:

<g:batch se:sline="1" se:scol="0" se:eline="2" se:ecol="30">
<g:statements>
  <pu:semicolon se:sline="1" se:scol="0" se:eline="1" se:ecol="1" se:type="opt+">
    <g:statement se:sline="1" se:scol="0" se:eline="2" se:ecol="30">
    ...
    </g:statement>
  </pu:semicolon>
</g:statements>
</g:batch>