insert into routes
  (table_period_id, route_id, route_short_name, route_long_name, route_type, route_alias, direction_id, route_direction_name)
values
  (${table_period_id}, ${route_id}, ${route_short_name}, ${route_long_name}, ${route_type}, ${route_alias}, ${direction_id}, ${route_direction_name})
returning *
