Custom SQL Query Unable to Create Line Chart Based On Query

I am writing a custom sql query. When I use the Date(created) sql function and group by date(created) I cannot visualize the data through Metabase. It gives me the issue
“We couldn’t create a line chart based on your query.”

An example of this query would be

SELECT Date(created), count(*)
GROUP BY DATE(created)

I think the problem is that the backend is not returning a base_type for the calculated field so the frontend doesn’t know it’s considered a metric. I think the backend should set the base_type depending on the calculated column’s formula.

Similar issue here