Re:I don't want to learn your query language
by TheCoelacanth on Saturday September 01, 2018 @12:02PM
(#17892425)
What you really mean is that all of the major DB engines created their own query language for dealing with full-text search. None of those things are SQL, they are extensions to SQL.
[ Parent
| on HN ]
Re:I don't want to learn your query language
by ddebernardy on Saturday September 01, 2018 @03:23PM
(#17893503)
If memory serves me well, ANSI SQL (the W3C of SQL) recommends the syntax adopted by TSQL and DB2. So technically, some flavors of this are not extensions to SQL, but indeed part of it.
Think of it as browser prefixes. Sooner or later all engines agree on a common syntax, with each one needing to support some legacy code.
And in contrast with what happens when you use some third party app, you can further filter matched rows, join them with other tables to your heart's contents, aggregate them, apply window functions, and what have you.