In SQL, double quotes can be used to enclose identifiers that contain spaces or special characters. To append double quotes around an identifier, simply place them on either side of the identifier name, like this: "identifier". To remove double quotes from an identifier, you can use the REPLACE function with an empty string as the second parameter, like this: REPLACE("identifier",'"','').