Query: lambda_function_use_latest_runtime

select
  address as resource,
  case
    when (attributes_std ->> 'runtime') is null then 'skip'
    when (attributes_std ->> 'runtime') in (
      'nodejs14.x',
      'nodejs12.x',
      'nodejs10.x',
      'python3.8',
      'python3.7',
      'python3.6',
      'ruby2.5',
      'ruby2.7',
      'java11',
      'java8',
      'go1.x',
      'dotnetcore2.1',
      'dotnetcore3.1'
    ) then 'ok'
    else 'alarm'
  end as status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'runtime') is null then ' runtime not set'
    when (attributes_std ->> 'runtime') in (
      'nodejs14.x',
      'nodejs12.x',
      'nodejs10.x',
      'python3.8',
      'python3.7',
      'python3.6',
      'ruby2.5',
      'ruby2.7',
      'java11',
      'java8',
      'go1.x',
      'dotnetcore2.1',
      'dotnetcore3.1'
    ) then ' uses latest runtime - ' || (attributes_std ->> 'runtime') || '.'
    else ' uses ' || (attributes_std ->> 'runtime') || ' which is not the latest version.'
  end as reason,
  path || ':' || start_line
from
  terraform_resource
where
  type = 'aws_lambda_function';