{
    yancy => {
        backend => 'sqlite:./northwind.sqlite',
        schema => {
            products => {
                properties => {
                    supplier_id => {
                        'x-foreign-key' => 'suppliers',
                        'x-display-field' => 'company_name',
                    },
                },
            },
            orders => {
                properties => {
                    ship_via => {
                        'x-foreign-key' => 'shippers',
                        'x-display-field' => { template => '{company_name}: {phone}' },
                    },
                    customer_id => {
                        'x-foreign-key' => 'customers',
                        'x-display-field' => { template => '{contact_name} ({contact_title}, {company_name})' },
                    },
                    employee_id => {
                        'x-foreign-key' => 'employees',
                        'x-display-field' => { template => '{first_name} {last_name} ({title})' },
                    },
                },
            },
            order_details => {
                properties => {
                    order_id => {
                        'x-foreign-key' => 'orders',
                        'x-display-field' => { template => '{order_id} (to: {ship_name})' },
                    },
                    product_id => {
                        'x-foreign-key' => 'products',
                        'x-display-field' => 'product_name',
                    },
                },
            },
            employees => {
                properties => {
                    reports_to => {
                        'x-foreign-key' => 'employees',
                        'x-display-field' => { template => '{first_name} {last_name} ({title})' },
                    },
                },
            },
        },
    },
}