Null case comparisons in SQLite#

1
  case
2
    when (media_url_https is not null) then json_object('img_src', media_url_https, 'width', 300)
3
  end as photo

1
select
2
  created_at,
3
  regexp_match('.*?(\d+(\.\d+))lb.*', full_text, 1) as lbs,
4
  full_text,
5
  case
6
    when (media_url_https is not null) then json_object('img_src', media_url_https, 'width', 300)
7
  end as photo
8
from
9
  tweets
10
  left join media_tweets on tweets.id = media_tweets.tweets_id
11
  left join media on media.id = media_tweets.media_id
12
where
13
  full_text like '%lb%'
14
  and user = 3166449535
15
  and lbs is not null
16
group by
17
  tweets.id
18
order by
19
  created_at