Q:

TYPO3 typoscript WHERE anotation, what is the difference?

In selecting specific content I collect only the elements from the column that has colPos = 1, I have two annotations that work for the where clause and I'd like to understand the difference;
10 = CONTENT
10 {
    table = tt_content
    select {
        pidInList = this
        orderBy = sorting
        where = {#colPos}=1
        where = colPos = 1
    }
    renderObj = COA
    renderObj {
        10 = TEXT
        10.stdWrap.field = header
    }
}

A:

The first version ensures proper quoting for SQL field names, the second version does not. This ensures compatibility with various DBMS. You should always use the first version if possible.
The annotation with the curly brackets has been introduced in TYPO3 V8.

