# Changing SELECT .. FROM Into FROM .. SELECT Does Not "Fix" SQL

DevFeed: [Changing SELECT .. FROM Into FROM .. SELECT Does Not "Fix" SQL](<https://devfeed.tech/articles/changing-select-from-into-from-select-does-not-fix-sql-28934.md>)

Original publisher: [Read original article](<https://blog.jooq.org/changing-select-from-into-from-select-does-not-fix-sql/>)

Author: lukaseder

Published: 2022-05-31T08:39:55Z

Content type: opinion

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [ordering](<https://devfeed.tech/topics/ordering.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Programming](<https://devfeed.tech/topics/programming.md>)

Tags: [jooq](<https://devfeed.tech/tags/jooq.md>), [jooq-development](<https://devfeed.tech/tags/jooq-development.md>), [operations](<https://devfeed.tech/tags/operations.md>), [order-of-operations](<https://devfeed.tech/tags/order-of-operations.md>), [rdbms](<https://devfeed.tech/tags/rdbms.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-syntax](<https://devfeed.tech/tags/sql-syntax.md>), [syntax](<https://devfeed.tech/tags/syntax.md>)

## AI overview

The article examines the difference between SQL's lexical order, such as SELECT .. FROM, and its logical order of operations, such as FROM .. SELECT. It argues that changing the syntax would improve logical consistency but would not fully fix SQL, and discusses jOOQ's support for alternative forms and variations across database systems.

## Source excerpt

Every now and then, I see folks lament the SQL syntax's peculiar disconnect between the lexical order of operations (SELECT .. FROM) the logical order of operations (FROM .. SELECT) Most recently here in a Youtube comment reply to a recent jOOQ/kotlin talk. Let's look at why jOOQ didn't fall into this trap of trying ... Continue reading Changing SELECT .. FROM Into FROM .. SELECT Does Not "Fix" SQL ->