Upgrading to 2018.1 has caused all my public static final constants to have compiler errors

More details. It appears to only affect constants that end with _COL

It seems to only affect constants that are referenced in SQL code

Try un-injecting the SQL from the strings: https://www.jetbrains.com/help/idea/using-language-injections.html.

It looks like it only affects constants that are used in SQL queries. 

That being said I apologize but I'm not sure what you're referring to Serge. I don't see any option to un-inject...

See the link. Alt+Enter inside the string.

I don't have that option. Attached is a screenshot

That option only seems to appear on constants that aren't used in SQL queries.

Below is the code in case it helps:

public class PeopleSQL
{
   public static final String ID_COL = "id";
   public static final String FIRSTNAME_COL = "firstname";
   public static final String LASTNAME_COL = "lastname";

   public static void getListOfPeople(Connection connection) throws RanaSQLException
   {
      PreparedStatement statement = null;
      ResultSet result = null;

      try
      {
         statement = connection.prepareStatement("SELECT " + ID_COL + ", " + LASTNAME_COL + " FROM people");
         result = statement.executeQuery();

      } catch (SQLException e) {
         e.printStackTrace();
      } finally {
         try
         {
            result.close();
            statement.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
   }
}

class People
{

}

It appears to be a bug, as a workaround you can disable this injection: https://i.imgur.com/bUS579f.png.

Bug reported at https://youtrack.jetbrains.com/issue/IDEA-188988, thanks.

Thank you, I've just disabled it until the bug is fixed. 

I also submitted a ticket but haven't gotten a response. When I get a response I'll point them to here.