title: Possible to emulate a basic CTE in MySQL by in-lining it
body: <p>There have been various questions about this but I'm not sure if they address this particular aspect of it. Let's say we have the following query on a non-recursive, non-volatile, non-depdendent CTE?</p>
  <pre><code>WITH tbl AS (
        SELECT 1 AS a
    ) SELECT * FROM tbl
  </code></pre>
  <p>Is it possible and valid to always replace <code>tbl</code> with a sub-select that the CTE refers to? For example:</p>
  <pre><code>SELECT * FROM (SELECT 1 AS a) myCTE
  </code></pre>