SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.title == "Software Engineer" && @.location == "San Francisco").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Software Engineer San Francisco') -- general full text search
  AND parsed_data @> '{"experiences": [{"ends_at": null, "title": "Software Engineer", "location": "San Francisco"}]}' -- confirm
                        
                    

                        
                            
SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company_linkedin_profile_url == "https://www.linkedin.com/company/apple/").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'https://www.linkedin.com/company/apple/')
  AND parsed_data @> '{"experiences": [{"ends_at": null, "company_linkedin_profile_url": "https://www.linkedin.com/company/apple/"}]}'
                        
                    

                        
                            
SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.education[*] ? (@.field_of_study == "Computer Science" && @.school == "Standford University").degree_name') AS degree_name
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Standford University Computer Science') -- general full text search
  AND parsed_data @> '{"education": [{"school": "Standford University", "field_of_study": "Computer Science"}]}' -- confirm
                        
                    

                        
                            
SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
  AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm