If a query uses an alias that is the same as a base column name and you create a calculated field using the ambiguous name, the query will produce different results under each query mode.
1	If	if	SCONJ	_	_	4	mark	_	_
2	a	a	DET	IND-SG	Definite=Ind|PronType=Art	3	det	_	_
3	query	query	NOUN	SG-NOM	Number=Sing	4	nsubj	_	_
4	uses	use	VERB	PRES	Mood=Ind|Number=Sing|Person=3|Tense=Pres|VerbForm=Fin	30	advcl	_	_
5	an	an	DET	IND-SG	Definite=Ind|PronType=Art	6	det	_	_
6	alias	alias	NOUN	SG-NOM	Number=Sing	4	obj	_	_
7	that	that	PRON	REL	PronType=Rel	10	nsubj	_	_
8	is	be	AUX	PRES	Mood=Ind|Number=Sing|Person=3|Tense=Pres|VerbForm=Fin	10	cop	_	_
9	the	the	DET	DEF	Definite=Def|PronType=Art	10	det	_	_
10	same	same	ADJ	POS	Degree=Pos	6	acl:relcl	_	_
11	as	as	ADP	_	_	15	case	_	_
12	a	a	DET	IND-SG	Definite=Ind|PronType=Art	15	det	_	_
13	base	base	NOUN	SG-NOM	Number=Sing	14	compound	_	_
14	column	column	NOUN	SG-NOM	Number=Sing	15	compound	_	_
15	name	name	NOUN	SG-NOM	Number=Sing	10	nmod	_	_
16	and	and	CCONJ	_	_	18	cc	_	_
17	you	you	PRON	PERS-P2	_	18	nsubj	_	_
18	create	create	VERB	PRES	Mood=Ind|Tense=Pres|VerbForm=Fin	10	conj	_	_
19	a	a	DET	IND-SG	Definite=Ind|PronType=Art	21	det	_	_
20	calculated	calculate	ADJ	PASS	Case=Nom	21	amod	_	_
21	field	field	NOUN	SG-NOM	Number=Sing	18	obj	_	_
22	using	use	VERB	ING	Tense=Pres|VerbForm=Part	18	advcl	_	_
23	the	the	DET	DEF	Definite=Def|PronType=Art	25	det	_	_
24	ambiguous	ambiguous	ADJ	POS	Degree=Pos	25	amod	_	_
25	name	name	NOUN	SG-NOM	Number=Sing	22	obj	_	SpaceAfter=No
26	,	,	PUNCT	Comma	_	4	punct	_	_
27	the	the	DET	DEF	Definite=Def|PronType=Art	28	det	_	_
28	query	query	NOUN	SG-NOM	Number=Sing	30	nsubj	_	_
29	will	will	AUX	PRES-AUX	VerbForm=Fin	30	aux	_	_
30	produce	produce	VERB	INF	VerbForm=Inf	0	root	_	_
31	different	different	ADJ	POS	Degree=Pos	32	amod	_	_
32	results	result	NOUN	PL-NOM	Number=Plur	30	obj	_	_
33	under	under	ADP	_	_	36	case	_	_
34	each	each	DET	TOT-SG	_	36	det	_	_
35	query	query	NOUN	SG-NOM	Number=Sing	36	compound	_	_
36	mode	mode	NOUN	SG-NOM	Number=Sing	30	obl	_	SpaceAfter=No
37	.	.	PUNCT	Period	_	30	punct	_	_
