select 
'table' as component,
'/examples/show_variables.sql?action=edit&update_id={id' as edit_url,
'/examples/show_variables.sql?action=delete&delete_id={id' as delete_url,
JSON_OBJECT('name':'history','tooltip':'View Standard History','link':'/examples/show_variables.sql?action=history&standard_id={id}','icon':'as') as custom_actions;
select 
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'T23523' as 'lot number',
'Available' as status,
'2026-10-13' as 'expires on',
32 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action','tooltip':'Set In Use','link':'/examples/show_variables.sql?action=set_in_use&standard_id=32','icon':'caret-right') as _sqlpage_actions;
select 
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'T2352' as 'lot number',
'In Use' as status,
'2026-10-14' as 'expires on',
33 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action','tooltip':'Retire Standard','link':'/examples/show_variables.sql?action=retire&standard_id=33','icon':'test-pipe-off') as _sqlpage_actions;
select 
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'A123' as 'lot number',
'Discarded' as status,
'2026-09-30' as 'expires on',
31 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action') as _sqlpage_actions;