Insights/creation UI pings

Created by: coury-clark

⚠️ Just a reminder (mostly for myself) that this can't be merged until the schema for BigQuery is updated ⚠️

Closes #21527 (closed)

This PR includes the ping queries and updates to the ping request object for code insights creation UI p1