bricks_create_custom_query

bricks_create_query_handler({
  name: "custom_events",
  label: "Events (Custom Table)",
  query_function: `
    global $wpdb;
    $table = $wpdb->prefix . 'events';
    $limit = isset($query_args['posts_per_page']) ? intval($query_args['posts_per_page']) : 10;
    $results = $wpdb->get_results(
      $wpdb->prepare("SELECT * FROM {$table} WHERE event_date >= %s ORDER BY event_date ASC LIMIT %d", current_time('Y-m-d'), $limit)
    );
    return $results ?: [];
  `,
  loop_object_function: `
    // Make each event accessible via dynamic data
    global $bricks_loop_item;
    $bricks_loop_item = $loop_item;
  `
});

The query_function has access to $query_args which contains all the settings from the Bricks query UI. Use these to make your handler configurable from the editor.

For external APIs, consider caching responses with WordPress transients to avoid hitting rate limits and improve performance.

Test the handler manually by creating a simple query loop after registration to verify data is returned correctly before building the full page layout.