sql_mapping

'formatting' group (
	'identifier wrapping' ['identifier-delimiter:'] group (
		'open' text
		'close' text
	)
	'data type mapping' ['data-types'] group (
		'key' ['key:'] text
		'text' ['text:'] text
		'number' ['number:'] text
		'state' ['state:'] text
	)
)

'tables' ['schema'] collection indent (
	'table' component 'table'
	'primary key' ['<--'] group (
		'root key field' stategroup (
			'no'
				'entity type path' component 'entity type path'
			'yes'
				'root key' ['(',')'] text
		)
		'key fields' collection ( ['[']
			'has predecessor' stategroup has predecessor 'predecessor' 'yes' 'no'
			'has successor' stategroup has successor 'successor' 'yes' 'no'
			'has tail' [']'] stategroup (
				'no'
				'yes'
					'entity type path' component 'entity type path'
			)
		)
		'has key fields' stategroup has 'key fields' first 'first' last 'last' 'yes' 'no'
	)
	'fields' ['{','}'] collection indent (
		'has successor' stategroup has successor 'successor' 'yes' 'no'
		'type' [':'] stategroup (
			'key'
				'type' stategroup (
					'primary key' ['primary-key']
					'foreign key' ['foreign-key']
				)
			'text' ['text']
			'number' ['number']
			'state' ['state']
				'values' ['(', ')'] collection ( )
		)
	)
	'has fields' stategroup has 'fields' first 'first' 'yes' 'no'
)

'undefined table' component 'table'

'root table' ['mapping' 'root'] component 'optional table selection'

'mapping' component 'mapping definition'

'entity scoped node type path'
	'has steps' stategroup (
		'no'
		'yes'
			'type' stategroup (
				'group'
					'group' ['+'] reference
				'state'
					'state group' ['?'] reference
					'state' ['|'] reference
			)
			'tail' component 'entity scoped node type path'
	)

'entity type path'
	'head' component 'entity scoped node type path'
	'collection' ['.'] reference

'table'

'table selection'
	'table' ['-->' 'table'] reference

'optional table selection'
	'select table' stategroup (
		'yes'
			'table' component 'table selection'
		'no'
	)

'mapping definition' ['(',')']
	'properties' collection (
		'include' stategroup (
			'no' ['(ignore)']
			'yes'
				'type' [':'] stategroup (
					'text' ['text']
						'has constraint' stategroup (
							'no'
								'field' ['-->'] reference
							'yes' ['(->)']
								'field' ['-->'] reference
						)
					'number' ['number']
						'field' ['-->'] reference
					'file' ['file']
						'token field' ['-->'] reference
						'extension field' ['.'] reference
					'group' ['group']
						// 'optional table' component 'optional table selection'
						'mapping' component 'mapping definition'
					'state group' ['stategroup']
						'state group to field mapping' stategroup (
							'no'
							'yes' ['-->']
								'field' reference // reference !&'table'.'fields'
						)
						'states' ['(',')'] collection ( ['|']
							'state to state value mapping' stategroup (
								'no'
								'yes' ['-->']
									'value' reference
							)
							// 'optional table' component 'optional table selection'
							'mapping' component 'mapping definition'
						)
					'collection' ['collection']
						'table' component 'table selection'
						'mapping' component 'mapping definition'
				)
		)
	)