I recognize the syntax in "date_trunc('day', created_at)::date as day,", namely the cast "::date", as PostgreSQL syntax. Could be something else as well but I've only seen it with PostgreSQL.