Selection of variable types in native query

When the variable type is selected as text or field filter condition, is the SQL statement written in the same way? What are the requirements for columns when selecting field filter conditions?

Hi @sugar
Please don’t create multiple topics about the same question.
Read the documentation:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html
Or the articles:
https://www.metabase.com/blog/field-filters/index.html
https://www.metabase.com/blog/sql-template-variables/index.html