TYPEOF

1
SELECT
2
  TYPEOF(123) AS int_type,
3
  TYPEOF('hello') AS str_type,
4
  TYPEOF(1.5) AS float_type,
5
  TYPEOF(true) AS bool_type;

1
SELECT DISTINCT
2
  TYPEOF(price) AS price_type,
3
  TYPEOF(created_at) AS date_type
4
FROM products
5
LIMIT 1;

1
SELECT
2
  value,
3
  TYPEOF(value) AS type
4
FROM json_data
5
WHERE TYPEOF(value) != 'VARCHAR';

1
SELECT
2
  column_name,
3
  TYPEOF(value) AS detected_type
4
FROM (
5
  SELECT 'id' AS column_name, id AS value FROM products
6
  UNION ALL
7
  SELECT 'name', name FROM products
8
  UNION ALL
9
  SELECT 'price', price FROM products
10
) t
11
GROUP BY column_name, detected_type;