Core BETA

// Fetch a single user from the users table with ID 'user-1', 
// including their orders and the products in those orders.

const userWithOrdersAndProducts = await manta.fetchOneRecord({
table: 'users',
where: { user_id: 'user-1' },
fields: ['user_id', 'first_name', 'last_name'],
with: {
  orders: {
    fields: ['order_id', 'product_id', 'amount'],
    on: { from: 'user_id', to: 'customer_id' },
    with: {
      products: {
        fields: ['product_id', 'name', 'price'],
        on: { from: 'product_id', to: 'product_id' }
      }
    }
  }
}
});

// Create one or more user records in the users table with built-in validation.

await manta.createRecords({
table: 'users',
data: [
  {
    email: 'real@example.com',
    username: 'John Doe',
    validation: { // Per-row validation rules
      username: { required: true, regex: /^[a-z0-9_]{3,16}$/ },
      email: { required: true, format: 'email' }
    }
  },
  { email: 'not-an-email' }
],
options: { validationRules: { email: { format: 'email' } } } // Global validation rules
});