Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

sql dynamic-sql

sql

Drop all tables whose names begin with a certain string

sql sql-server dynamic-sql

sql

Create PostgreSQL ROLE (user) if it doesn't exist

sql postgresql roles dynamic-sql

sql

SQL update fields of one table from fields of another one

sql postgresql sql-update dynamic-sql

sql

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

sql sql-server tsql dynamic-sql

sql

Declare Variable for a Query String

sql sql-server sql-server-2005 tsql dynamic-sql

sql

How to use table variable in a dynamic sql statement?

sql sql-server sql-server-2008 dynamic-sql table-variable

sql

nvarchar(max) still being truncated

sql sql-server-2008 dynamic-sql

sql

What is dynamic SQL?

mysql sql stored-procedures dynamic-sql

sql

Refactor a PL/pgSQL function to return the output of various SELECT queries

sql database postgresql plpgsql dynamic-sql

sql

PostgreSQL convert columns to rows? Transpose?

sql postgresql pivot-table dynamic-sql crosstab

sql

PostgreSQL - dynamic value as table name [duplicate]

sql postgresql postgresql-9.1 dynamic-sql

sql

Oracle: DBMS_UTILITY.EXEC_DDL_STATEMENT vs EXECUTE IMMEDIATE

sql oracle dynamic-sql ddl

sql

How to join to tables whose names are stored as values in another table?

sql sql-server sql-server-2012 dynamic-sql cursors

sql

Generate Delete Statement From Foreign Key Relationships in SQL 2008?

sql code-generation foreign-keys dynamic-sql

sql