Re: [VOTE] FROM-first syntax clause ordering

[Chen Zhehan]

Hi Abdelrahman:


I also vote for Option A.

Best regards,
Zhehan Chen




         原始邮件
         
       
发件人：Yuan Tian <jackietie...@gmail.com&gt;
发件时间：2026年3月27日 08:41
收件人：dev <dev@iotdb.apache.org&gt;
主题：Re: [VOTE] FROM-first syntax clause ordering



       Hi&nbsp;Abdelrahman,

I&nbsp;would&nbsp;like&nbsp;to&nbsp;cast&nbsp;my&nbsp;vote&nbsp;for&nbsp;Option&nbsp;A&nbsp;(FROM&nbsp;relation&nbsp;SELECT&nbsp;WHERE).

My&nbsp;main&nbsp;reasons&nbsp;for&nbsp;preferring&nbsp;this&nbsp;option&nbsp;are:

-&nbsp;Consistency:&nbsp;It&nbsp;aligns&nbsp;with&nbsp;the&nbsp;approach&nbsp;used&nbsp;in&nbsp;DuckDB,&nbsp;which&nbsp;helps
maintain&nbsp;consistency&nbsp;and&nbsp;provides&nbsp;a&nbsp;more&nbsp;familiar&nbsp;experience&nbsp;for&nbsp;users
migrating&nbsp;from&nbsp;other&nbsp;systems.
-&nbsp;Ease&nbsp;of&nbsp;Adoption:&nbsp;Leveraging&nbsp;an&nbsp;existing&nbsp;implementation&nbsp;pattern&nbsp;can
reduce&nbsp;the&nbsp;learning&nbsp;curve&nbsp;for&nbsp;our&nbsp;users.

Best&nbsp;regards,

Yuan&nbsp;Tian


On&nbsp;Thu,&nbsp;Mar&nbsp;26,&nbsp;2026&nbsp;at&nbsp;5:32 
PM&nbsp;Abdelrahman&nbsp;Mostafa&nbsp;<
abdo.mostafa....@gmail.com&gt;&nbsp;wrote:

&gt;&nbsp;Hi&nbsp;all,
&gt;
&gt;&nbsp;Following&nbsp;the&nbsp;discussion&nbsp;on&nbsp;adding&nbsp;FROM-first&nbsp;syntax&nbsp;support&nbsp;to&nbsp;IoTDB's
&gt;&nbsp;Table&nbsp;SQL&nbsp;dialect,&nbsp;I&nbsp;would&nbsp;like&nbsp;to&nbsp;initiate&nbsp;a&nbsp;vote&nbsp;on&nbsp;the&nbsp;clause&nbsp;ordering.
&gt;
&gt;&nbsp;We&nbsp;currently&nbsp;have&nbsp;two&nbsp;options:
&gt;
&gt;&nbsp;Option&nbsp;A:&nbsp;(FROM&nbsp;relation&nbsp;SELECT&nbsp;WHERE)
&gt;
&gt;&nbsp;Example:&nbsp;FROM&nbsp;sensors&nbsp;SELECT&nbsp;temperature&nbsp;WHERE&nbsp;temperature&nbsp;&gt;&nbsp;15
&gt;
&gt;&nbsp;Option&nbsp;B:&nbsp;(FROM&nbsp;relation&nbsp;WHERE&nbsp;SELECT)
&gt;
&gt;&nbsp;Example:&nbsp;FROM&nbsp;sensors&nbsp;WHERE&nbsp;temperature&nbsp;&gt;&nbsp;15&nbsp;SELECT&nbsp;temperature
&gt;
&gt;&nbsp;Both&nbsp;options&nbsp;share&nbsp;the&nbsp;same&nbsp;core&nbsp;benefits,&nbsp;including&nbsp;better&nbsp;IDE/CLI
&gt;&nbsp;auto-completion&nbsp;and&nbsp;quick&nbsp;data&nbsp;exploration,&nbsp;since&nbsp;they&nbsp;both&nbsp;start&nbsp;with
&gt;&nbsp;FROM.
&gt;&nbsp;The&nbsp;difference&nbsp;is:
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;Option&nbsp;A&nbsp;aligns&nbsp;with&nbsp;the&nbsp;approach&nbsp;used&nbsp;in&nbsp;DuckDB,&nbsp;helping&nbsp;maintain
&gt;&nbsp;&nbsp;&nbsp;&nbsp;consistency&nbsp;with&nbsp;the&nbsp;existing&nbsp;implementation&nbsp;and&nbsp;making&nbsp;it&nbsp;more
&gt;&nbsp;familiar&nbsp;to
&gt;&nbsp;&nbsp;&nbsp;&nbsp;users&nbsp;migrating&nbsp;from&nbsp;other&nbsp;systems.
&gt;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;Option&nbsp;B&nbsp;aligns&nbsp;better&nbsp;with&nbsp;the&nbsp;actual&nbsp;execution&nbsp;logic&nbsp;and&nbsp;human
&gt;&nbsp;&nbsp;&nbsp;&nbsp;thought&nbsp;process:&nbsp;first,&nbsp;you&nbsp;define&nbsp;the&nbsp;data&nbsp;source&nbsp;(FROM),&nbsp;then&nbsp;you
&gt;&nbsp;filter
&gt;&nbsp;&nbsp;&nbsp;&nbsp;it&nbsp;(WHERE),&nbsp;and&nbsp;finally,&nbsp;you&nbsp;choose&nbsp;what&nbsp;to&nbsp;project&nbsp;(SELECT)
&gt;
&gt;&nbsp;For&nbsp;more&nbsp;context,&nbsp;please&nbsp;refer&nbsp;to&nbsp;the&nbsp;discussion&nbsp;thread:
&gt;&nbsp;https://lists.apache.org/thread/p1psfm5y9zo270tn75rz1cdglff7ogc8
&gt;
&gt;&nbsp;Please&nbsp;share&nbsp;your&nbsp;preference&nbsp;(Option&nbsp;A&nbsp;or&nbsp;Option&nbsp;B)&nbsp;and&nbsp;any&nbsp;additional
&gt;&nbsp;thoughts.
&gt;
&gt;&nbsp;Best&nbsp;regards,
&gt;
&gt;&nbsp;Abdelrahman
&gt;